View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default 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!!