Using lookup in a VBA procedure
 

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
--
dilettante

Using lookup in a VBA procedure
 

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)

"dilettante" wrote in message
...
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
--
dilettante