View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 74
Default Delete first character in ActiveCell

try this code after highllightig the concerned cell

Public Sub test()
Dim mystring As String
mystring = Left(ActiveCell, 1)
MsgBox mystring
With ActiveCell
..Replace what:=mystring, replacement:=""
End With
End Sub

Andy wrote in message
...

What would the code be to delete the first character in the Active
Cell? So abc123 would become bc123? It's easy to add a character to
the beginning of the string, but I can't figure out how to delete it.

TIA,

Andy