View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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.