Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 cell limit
(i'm using Visual Studio 2005 and Excel 2003 -- cross posted in vc.mfcole
group) i have read that Excel 2003's char limit for a cell is 32,767 chars, of which only 1024 are displayable in the cell (the remainder are visible in the expanded command line (or whatever it's called...at the top of the worksheet)). that's fine. however, i have text that is 1405 chars and Range.put_Value(str_1405) fails unless i set str_1405 = left(str_1405, 910). the actual max value is somewhere between 910 and 925. since i'm well below the 32,767 limit i feel this should work. has anyone else run into this? suggestions?? i've tried Range.NoteText(vStr, vStart, vEnd) and it always fails w/ "type mismatch). i've tried Range.AddComment(vStr) - it fails like NoteText, although i'm not sure that a Comment is the same as a Note. tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting #ref error after row / cell is this a limit in excel 2003 tia sal2 | Excel Discussion (Misc queries) | |||
Getting #ref error after row / cell is this a limit in excel 2003 tia sal2 | Excel Worksheet Functions | |||
Getting #ref error after row / cell is this a limit in excel 2003 tiasal2 | Excel Discussion (Misc queries) | |||
Getting #ref error after row / cell is this a limit in excel 2003 tiasal2 | Excel Worksheet Functions | |||
columns limit in excel 2003 | Excel Discussion (Misc queries) |