LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to activate macro from cell artzuka Excel Discussion (Misc queries) 2 January 6th 09 09:12 PM
button in a cell to activate a macro alexfair Excel Worksheet Functions 6 May 30th 08 03:09 PM
Click cell to activate macro Bob[_68_] Excel Programming 7 February 27th 06 04:18 PM
activate a cell value through a macro TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 November 10th 05 08:48 AM
Activate Userform (run macro?) from cell value ziggyg[_3_] Excel Programming 1 April 13th 04 04:45 AM


All times are GMT +1. The time now is 06:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"