About Us

Kevin T. Ryan[_2_]

Thanks guys, worked like a charm!!

"Alan Beban" wrote in message
...
Tom Ogilvy wrote:
a single row will never exceed 256, so no problem with that. A single
column must be less than or equal to 5461 cells for this to work:

This limit doesn't apply in xl2000 SR-1 and, I assume, later. In that
version and earlier (and maybe later, I don't know) the 5461 element
limit on the Index function, which Tom may have been thinking of, still
applies.

Alan Beban

Sub tester9()
Dim varrHoriz
Dim varrVert
On Error Resume Next
varrHoriz = Application.Transpose(Application.Transpose(Range( "A1:F1")))
Debug.Print UBound(varrHoriz, 1)
Debug.Print UBound(varrHoriz, 2)
varrVert = Application.Transpose(Range("A1:A10"))
Debug.Print UBound(varrVert, 1)
Debug.Print UBound(varrVert, 2)

End Sub

This will produce a 1D array for a single row, or single column range

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array formula: how to join 2 ranges together to form one array?	Rich_84	Excel Worksheet Functions	2	April 1st 09 06:38 PM
Filter an array	hntsignif	Links and Linking in Excel	1	December 13th 08 12:48 PM
Join tables like inner join in Access	ryanp	Excel Discussion (Misc queries)	2	July 18th 08 03:35 PM
Conditional filter using array formula	[email protected]	Excel Worksheet Functions	6	June 10th 08 03:03 AM
Conditional filter using array formula	[email protected]	Excel Worksheet Functions	0	June 3rd 08 05:34 AM

Menu

About Us