| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string size limitations for array formulas
From scanning previous posts, it seems that any VBA code using .FormulaArray
to take a string and use it to put an array formula into a cell is limited to a string size of 255 characters. if I use VBA code similar to the following... answer = Evaluate("some array formula string here") Sheet1.Range("D1") = answer am I restricted by the same string size limitation? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
string size limitations for array formulas
Think of Evaluate or [] as being a virtual cell - so you would have the same
limitations. -- Regards, Tom Ogilvy "David Fazenbaker" wrote: From scanning previous posts, it seems that any VBA code using .FormulaArray to take a string and use it to put an array formula into a cell is limited to a string size of 255 characters. if I use VBA code similar to the following... answer = Evaluate("some array formula string here") Sheet1.Range("D1") = answer am I restricted by the same string size limitation? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why the arbitrary spreadsheet size limitations? | Excel Discussion (Misc queries) | |||
| Spreadsheet Size Limitations | Excel Discussion (Misc queries) | |||
| vlookup size limitations search range? | Excel Worksheet Functions | |||
| Size/memory limitations for vlookup fixed in the new Excel? | Excel Discussion (Misc queries) | |||
| size limitations on auto filter | Excel Discussion (Misc queries) | |||
Linear Mode
