Characters Object limitation?

N

nguy0531

I use this code to delete the first character in the cell.
*ActiveCell.Characters(1, 1).Delete* If the length of the cell conten
is less than 256 characters then the first character get deleted.
However, if the length is more than 256 characters then the firs
character is not deleted. Is there a limitation on the character
object? Is there any way I can delete the character when the lengt
is longer than 256 characters? Thanks for you hel
 
P

Paul Robinson

Hi
Rather than delete the first character, try replacing the string in
the cell with everything after the first character.

myString = ActiveCell.Text
ActiveCell.Value = Right(myString, Len(myString) - 1)

Works in Excel2002 under XP

regards
Paul
 
Top