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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Characters Object limitation? 11
256 character limitation 1
Column Cell character number checking 4
Map characters to their relative positions in a cell 3
Delete 1st character if string is longer than 6 characters 3
Character Analysis 11
Superscript/subscript selected text within a cell 3
Specify certain length(characters) when defining a column 3

Top