In row 1 of my worksheet I have a list of headers that contain dates. I need to write vba code that will select the cell(header) with a specific value in it.
Example,
if myVariable="11/28/2005" then I want to select the cell(header) with a value of 11/28/2005.
Logically I planned on using the MATCH worksheet function and then the ADDRESS worksheet function to return the cell address and then set the selection to the resulting address: Range(returnedaddress).Select
.....but this didn't work because the ADDRESS worksheet can't be used in VBA.
Can anyone help b/c I'm stumped?...thanks... [/list][/list]
Example,
if myVariable="11/28/2005" then I want to select the cell(header) with a value of 11/28/2005.
Logically I planned on using the MATCH worksheet function and then the ADDRESS worksheet function to return the cell address and then set the selection to the resulting address: Range(returnedaddress).Select
.....but this didn't work because the ADDRESS worksheet can't be used in VBA.
Can anyone help b/c I'm stumped?...thanks... [/list][/list]