Using lookup in a VBA procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Excel VBA 0
Lookup the date associated with a given value 2
Multiple Lookups 2
Double Lookup 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to lookup based in the first 3 characters of a cell 2
Lookup problems? 1

Back
Top