Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to get a macro to record F2, Home, Delete keystrokes
trying to edit the contents of a cell, but the macro acts as if I am typing
in whatever remains in the cell instead. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to get a macro to record F2, Home, Delete keystrokes
Excel lacks the type of keystroke macro recording ability that would allow
this. In VBA, you need to use something like this, which will remove the first character of a string in a cell: ActiveCell.Value = Mid(ActiveCell.Value, 2, Len(ActiveCell.Value)) HTH, Bernie MS Excel MVP "jenonstx" wrote in message ... trying to edit the contents of a cell, but the macro acts as if I am typing in whatever remains in the cell instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to record keystrokes ? | Excel Discussion (Misc queries) | |||
find last record in macro and delete all after | Excel Discussion (Misc queries) | |||
Macro to record keystrokes and not cell addresses | Excel Discussion (Misc queries) | |||
Make a macro of keystrokes. ie. F2,Shift & Home & right cursor,de. | Excel Worksheet Functions | |||
Record Keystrokes With Macro Recorder | Excel Programming |