Best way to paste a variant array into a range?

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
 
F

Frank Kabel

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

Alan Beban

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

Alan Beban
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For Eachcell in Range tranpose comma seperated values to a list in D 4
Variant Array Copy, Array row contains Object 5
Disconnected Range to Variant 4
Arrays and scattered cell values or another way? 16
Assignment of range to array problem 9
Array to Multiple Arrays 3
Cell values to an array, then array transpose to another workbook 8
Tried and true copy code lines fail me here 7

Top