View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Pouplating a list from an array

rw = 20
With Activesheet.Range("A1")
.Value = "Header1"
.Font.Bold = True
End with
Activesheet.Range("A2").Resize(rw,1).Value = Application.Transpose(v)
Activesheet.ListObjects.Add SourceType:=xlSrcRange, _
Source=Range("A1").Resize(rw+1,1)

would be my guess, although I don't have a copy xl2003 handy to test it
with.

for your own interpretation:
http://msdn.microsoft.com/library/en...HV03088209.asp

expand the Add method as it applies to ListObjects

--
Regards,
Tom Ogilvy


"thiaga" wrote in message
oups.com...
I am able to show them in the sheet with

'rw = Ubound(v,1) - lbound(v,1) + 1
Range("A1").Resize(rw,1).Value = Application.Transpose(v)
'
How to do it as in Create a List feature?