Pouplating a list from an array
Hi
Assuming your Variant is called myVariant then
myRows = UBound(myVariant,1)
myColumns = UBound(myVariant,2)
Range("A1").Resize(myRows, myColumns).Value = myVariant
will put your variant in the active sheet with top lefthand corner at
A1.
regards
Paul
thiaga wrote:
I have an array(Variant) of values.
I would like to show them as a list in the excel worksheet.
How do i do this? I am a newbie!!
|