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.
|