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