Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text is Truncated With String Variable
If I do this:
Dim theTxt as String theTxt = Activesheet.Cells(1,1).Text for some reason the text (which is actually 1849 characters long) is truncated to 1024 characters. If I do this: Dim theTxt as Variant theTxt = Activesheet.Cells(1,1) I get the complete text string from the cell. Can someone tell me why these two approaches are giving me different results? Thanks, Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text is Truncated With String Variable
One uses the .text property, the other uses the default property (.value).
EricG wrote: If I do this: Dim theTxt as String theTxt = Activesheet.Cells(1,1).Text for some reason the text (which is actually 1849 characters long) is truncated to 1024 characters. If I do this: Dim theTxt as Variant theTxt = Activesheet.Cells(1,1) I get the complete text string from the cell. Can someone tell me why these two approaches are giving me different results? Thanks, Eric -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text strings from a variable string | New Users to Excel | |||
find a variable text string | Excel Discussion (Misc queries) | |||
TextFrame.Characters.Text returns truncated string | Excel Programming | |||
variable amount truncated regardless of # of decimals | Excel Programming | |||
Getting text file into a VBA string variable | Excel Programming |