Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to activate macro from cell | Excel Discussion (Misc queries) | |||
button in a cell to activate a macro | Excel Worksheet Functions | |||
Click cell to activate macro | Excel Programming | |||
activate a cell value through a macro | Excel Discussion (Misc queries) | |||
Activate Userform (run macro?) from cell value | Excel Programming |