m = UBound(arr, 1) - LBound(arr, 1) + 1
n = UBound(arr, 2) - LBound(arr, 2) + 1
Set targetrng = Range("A1").Resize(m, n)
targetrng.Value = arr

Change "A1" as required

Alan Beban

Bharath Rajamani wrote:
Is there a way to paste the entire array directly to a worksheet. Assume the
array is unsorted, dynamically sized using Redim, and has 1mio values, and
can occupy all 256 columns and as many rows as required.

TIA!
BR


--
Capital Markets
GE Capital, London