Using lookup in a VBA procedure

D

dilettante

Hello
I am a beginner and I woul like to get the addres of the cell with a date,
choosen by lookup, to use its adress to check the date in the adiacent cell
so long as it is bigger the a given date.
Thank you for your help
 
B

Bob Phillips

look at Find in help to get the cell, then use Offset to get the adjacent
cell.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top