VBA Code using LOOKUP & OffSet

[Mazfam.1]

I have the date in column A descending from 1/1/2011 to 31/12/2011. I'd like some code that once activated, will go to the current date and then be offset by one cell to the right. Hope someone can help. Thanks

 

[Jon von der Heyden]

Hi and welcome to the board.

Do you want to return the range reference or do you want to return the value in that cell?

The latter would involve the Vlookup.

Dim x as Variant

x = Application.Vlookup(Date,Columns("A:B"),2,False)