Skywalker
11-09-2009, 05:28 PM
Hello,
I have column headings in row 1 of a worksheet and dates in column A (starting from row 2 onwards).
James Tom Alice Craig
21/04/2006
21/05/2006
22/06/2006
I would like to find the cell where the column and row match to pre-determined values: So for example, say I want to find the the cell where column heading in row 1 equals Orange and the date in column A equals 22-dec-2008.
So if orange is in column 6 (F1) and 22-dec-2008 occures in row 74 (A74), then I cell I'm looking for is F74.
Is there a way to find the cell using vba. I've seen some references to the intersect function but am having trouble using it. Hope someone can shed some light.
Some Notes:
1) Column headers from B1 to Q1
2) Dates are from A2 to A1647
3)All column and row values are unique
Thanks,
Skywalker
I have column headings in row 1 of a worksheet and dates in column A (starting from row 2 onwards).
James Tom Alice Craig
21/04/2006
21/05/2006
22/06/2006
I would like to find the cell where the column and row match to pre-determined values: So for example, say I want to find the the cell where column heading in row 1 equals Orange and the date in column A equals 22-dec-2008.
So if orange is in column 6 (F1) and 22-dec-2008 occures in row 74 (A74), then I cell I'm looking for is F74.
Is there a way to find the cell using vba. I've seen some references to the intersect function but am having trouble using it. Hope someone can shed some light.
Some Notes:
1) Column headers from B1 to Q1
2) Dates are from A2 to A1647
3)All column and row values are unique
Thanks,
Skywalker