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.

Macro to activate cell
 

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 wrote:

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

Macro to activate cell
 

That works great. Thanks!

"Dave Peterson" wrote:

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 wrote:

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