View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MEAD5432 MEAD5432 is offline
external usenet poster
 
Posts: 28
Default Macro to activate cell

I need a macro to simply activate a cell and then hit "Enter".

I have a list of numbers that I copied out of Access into Excel. In order
for my VLOOKUP formula to work, I need to go through and activate each cell
that holds the lookup value.

There are over 1,000 records in the list. Can I create a macro that will go
through and activate each cell without changing the value? As fast as I am
on the keyboard, it is going to take me forever if I have to hit F2 and ENTER
for each cell.

Thanks.