Best way to paste a variant array into a range?

  • Thread starter Thread starter AnneB
  • Start date Start date
A

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
 
Hi Anne
as this works (and is short and fast) why use something else :-)
As an addition: This is IMHO pretty efficient
 
Nope. And it doesn't matter whether the array is of Variant() type or
some other type.

Alan Beban
 
Back
Top