Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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/

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 Label Options - Forms Object vs Control Box Object Awrex Excel Discussion (Misc queries) 3 July 17th 09 07:10 PM
Exporting Access to Excel - Characters per cell limitation Bowtie63 Excel Discussion (Misc queries) 0 December 11th 07 09:42 PM
characters object limit Batailleye Excel Discussion (Misc queries) 4 June 26th 07 02:39 AM
cell to textframe using characters object Simon Prince Excel Programming 3 February 25th 04 06:10 AM
Range object to Array object conversion Tom Ogilvy Excel Programming 0 August 1st 03 12:16 AM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"