Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro formula array return limits?
In Excel 2007 i am trying to make use of the new row limits and have writen
the following macro Public Function testdata(size As Long) As Variant Dim BigArray() As Long Dim i As Long ReDim BigArray(0 To size, 0 To 1) As Long For i = 0 To size BigArray(i, 0) = i Next testdata = BigArray End Function I then try to set use the formula in excel. If i use = testdata(65535) the data is returned correctly. However as soon as I use 65535 for example = testdata(65536) all the cells fill with #Value Any help would be appreciated as I would like to make use of the 1M row limit in excel 2007 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with Array multiple return formula | Excel Discussion (Misc queries) | |||
Character Limits within an Array? | Excel Programming | |||
array formula: return next date from list | Excel Worksheet Functions | |||
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
ARRAY FORMULA-RETURN 0 INSTEAD OF #DIV/0 | Excel Worksheet Functions |