On Thursday, May 1, 2014 6:30:59 PM UTC-7, GS wrote:
Assuming this line has an object ref to a wks or rng...



.Cells(k, 1).Resize(UBound(arrOut) + 1, 1) = _

Application.Transpose(arrOut)



..you're 'good-to-go'!



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion


Yes, it is in a

With Sheets("A Name of sheet")

and also in a

For i = LBound(myArr) To UBound(myArr)

Howard

But your counter in the line of code is 'k' NOT 'i'!!!

--
Garry

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