| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want macro to select current cell
I want a very simple macro that, when run, will... Edit the current cell (wherever the user's cellpointer is when th macro is run) - edit being the same as striking F2 Paste Move down one row Without a macro, this is simple: F2 Ctrl-V Enter But I want just one keystroke that'll do this. Why is so difficult to simply tell a macro to edit or select whateve the cell the user is pointing to when they run the macro? All th macro tips I've read and all the help always end up with specific cel addresses. I really miss the old-time Lotus macros which recorded every singl keystroke {LEFT}{DOWN}{END}{RIGHT}, just to give an example. I digress. Help -- rdaughert ----------------------------------------------------------------------- rdaugherty's Profile: http://www.excelforum.com/member.php...fo&userid=2804 View this thread: http://www.excelforum.com/showthread.php?threadid=47551 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use current cell address as beginning of macro | Excel Discussion (Misc queries) | |||
| Referncing the current cell name in an Excel MACRO | Excel Discussion (Misc queries) | |||
| Data: select a cell x rows below the current, where x is designate | Excel Discussion (Misc queries) | |||
| Macro €“ select all cells in current range | Excel Discussion (Misc queries) | |||
| Macro to copy current cell | Excel Programming | |||
Threaded Mode
