Hi Howard,

Am Sat, 15 Feb 2014 14:56:35 -0800 (PST) schrieb L. Howard:

wksTarget.Range("F1").Resize(columnsize:=myRng.Cel ls.Count) =
myArr

if you know the number of items in your array you can also assign the
items to a range
wksTarget.Range("F1").Resize(columnsize:=myRng.Cel ls.Count)
is the same as
wksTarget.Range("F1:J1")
so you can write
wksTarget.Range("F1:J1") = myArr

Hmm.., When transfering an array to a worksheet target, I'm inclined to
resize to its UBound since the content of the output array may not be
the same size as its source range if it got modified during processing.
Using UBound covers it nicely!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion