ReDim Y(1 To UBound(X, 1) * UBound(X, 2), 1 To 8)

**sohaila** · 02-15-2014, 03:23 PM

please explain ReDim Y(1 To UBound(X, 1) * UBound(X, 2), 1 To 8)

**bsalv** · 02-15-2014, 03:28 PM

make the array Y with as rows the product of the number of rows of X (Ubound(x,1)) and the number of columns of X(ubound(x,2)) and 8 columns.
Both start with row 1 and column 1, that could have been 0 !

**AB33** · 02-15-2014, 03:45 PM

You left out the bit which looks like this line
x= range("A2").currentregion
How do I know? I am a mind-reader.

**Norie** · 02-15-2014, 05:48 PM

How is the array X defined?

ReDim Y(1 To UBound(X, 1) * UBound(X, 2), 1 To 8)

LinkBack

Thread Tools

Rate This Thread

Display

ReDim Y(1 To UBound(X, 1) * UBound(X, 2), 1 To 8)

Re: ReDim Y(1 To UBound(X, 1) * UBound(X, 2), 1 To 8)

Re: ReDim Y(1 To UBound(X, 1) * UBound(X, 2), 1 To 8)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] UBound and LBound

[SOLVED] LBound/UBound Intersect together

Ubound and Lbound

[SOLVED] resize(Ubound, Lbound)

Array Ubound

Bookmarks

Bookmarks

Posting Permissions