Best way to paste a variant array into a range?
 

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(vArr ay, 1)
UBound(vArray, 2)).Value = vArray

Thanks!

Ann

--
Message posted from http://www.ExcelForum.com

Best way to paste a variant array into a range?
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"AnneB " schrieb im Newsbeitrag
...
Hi, Does anyone know the best way to paste an array into a range? I
have
the following code that works, but I was wondering if there is a
better
way.

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

Thanks!

Anne


---
Message posted from http://www.ExcelForum.com/

Best way to paste a variant array into a range?
 

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

Alan Beban

AnneB < wrote:

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

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

Thanks!

Anne


---
Message posted from http://www.ExcelForum.com/