Thread: Macro/VBA code to select ALL text in a textbox in microsoft excel and add a new row
View Single Post
 
Old 05-29-2015, 01:12 PM
jyfuller jyfuller is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Jun 2012
Posts: 32
jyfuller is on a distinguished road
Default
Hi excelled software,

At the For statement at the end of the macro I also noticed that:

CountData =Oshp.TextFrame.Characters.Count+1

The number of characters in the cell is NOT being counted by the statement and the CountData variable is set to 1 character. I think this should be counting the number of characters in the entire length of text in the cell. I'm not sure why this is, but this is also a problem.

J
Reply With Quote