Thread: dim statements for worksheets array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RichardVisteon RichardVisteon is offline
external usenet poster
  
Posts: 8
Default dim statements for worksheets array
I am creating a macro in visual basic 6 for excel .I came across some code in
vb help to fill across sheets, eg.
x = Array("Sheet1", "Sheet5", sheet7")
Sheet(x).FillAcrossSheets _
Worksheets("Sheet1").Range("A1:C5")
But I am having trouble dimentioning the above code. Any suggestions please.
Reply With QuoteReply With Quote