View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Robinson Paul Robinson is offline
external usenet poster
 
Posts: 208
Default Characters Object limitation?

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

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


---
Message posted from http://www.ExcelForum.com/