Macro to activate cell

[MEAD5432]

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.

 

[Dave Peterson]

Instead of using a macro, how about this:

Select an empty cell
edit|copy
select the range to fix
edit|paste special|check Add

 

[MEAD5432]

That works great. Thanks!

Instead of using a macro, how about this:

Select an empty cell
edit|copy
select the range to fix
edit|paste special|check Add