| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit
Hi!
My case: I have an xls file with the only one worksheet. The first cell of this worksheet contains a text more then 4 kb length. The .Text property for that Cell returns only first 1024 characters. I see this in the following example: For Each ws In Worksheets MsgBox ws.Cells(1, 1).Value MsgBox ws.Cells(1, 1).Text Next ws Q: How can I get whole text from this cell? Thanks in advance! Bye. -- Alexei Baskakov |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel text export limit - 1024 per line (not cell), workaround? | Excel Discussion (Misc queries) | |||
| Importing text--cell text limit? | Excel Discussion (Misc queries) | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| Range.Formula in Excel 2003 gives Error reading formulas just below 1024 bytes | Excel Programming | |||
| Help with text box limit (1024) | Excel Programming | |||
Threaded Mode
