Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Could someone run the following code in Excel2007 with n=65535 and then
n=65537 and report the results? Sub abtest1 Dim arr1(), arr2(), iVar, n n = 65535 'n = 65537 ReDim arr1(1 To n, 1 To 1) arr1(4, 1) = "ok" On Error Resume Next arr2 = Application.Transpose(arr1) If Err < 0 Then MsgBox "Transpose doesn't work" Err = 0 End If iVar = Application.Index(arr1, 4, 1) If Err < 0 Then MsgBox "Index doesn't work" Err = 0 End If Debug.Print arr2(4), iVar End Sub Thanks, Alan Beban |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xl2007 limits on TRANSPOSE and INDEX functions? | Excel Programming | |||
Using Index to Transpose, Update Reference Cells as you Drag Down | Excel Worksheet Functions | |||
Array size limit when using WorksheetFunction.Transpose? | Excel Programming | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |