| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a Size limitation when writing from VB - Excel?
Dim objData as Variant
objData = <a string objXLWorkBook.Sheets("Sheet1").Range(<whatever).V alue = objData If objData is a string around 200 characters long, all is fine and my string gets written the the cell as expected. If objData is a string around 1000 character long, I get Error number 1004 "Applicaiton-defined or object-defined error". Is there a size limitation? I can manually enter 1000 characters into an Excel spreadsheet just fine. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file size limitation | Excel Discussion (Misc queries) | |||
| Excel Chart Series Values Property Size Limitation | Charts and Charting in Excel | |||
| Userform size limitation | Excel Programming | |||
| Array size limitation? | Excel Programming | |||
| SheetSelectionChange Target size Limitation? | Excel Programming | |||
Threaded Mode
