Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRANSPOSE and INDEX limit in Excel2007
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRANSPOSE and INDEX limit in Excel2007
65535 - ok ok
65537 - transpose doesn't work index doesn't work -- Jim "Alan Beban" wrote in message ... | 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRANSPOSE and INDEX limit in Excel2007
Jim Rech wrote:
65535 - ok ok 65537 - transpose doesn't work index doesn't work Thank you, Jim. That's interesting. In the excel.misc group, Roger Govier replied "Code runs and produces the debug result ok ok" I guess he didn't try it with n=65537. Thanks again, Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |