Select a row with a specific value in a given range

[mkingrey]

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]

 

[Barrie Davidson]

Something like?

Range("A1").Offset(, Application.WorksheetFunction.Match _
    (myVariable, Range("A1:Z1").Value, 0) - 1).Select

 

[mkingrey]

Thats worked pefectly,

thanks for the help!