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/