View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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