Best way to paste a variant array into a range?

[AnneB]

Hi, Does anyone know the best way to paste an array into a range? I hav
the following code that works, but I was wondering if there is a bette
way.

Worksheets("Sheet1").Cells(1,1).Resize(UBound(vArray, 1)
UBound(vArray, 2)).Value = vArray

Thanks!

Ann

 

[Frank Kabel]

Hi Anne
as this works (and is short and fast) why use something else
As an addition: This is IMHO pretty efficient

 

[Alan Beban]

Nope. And it doesn't matter whether the array is of Variant() type or
some other type.

Alan Beban