[dba-Tech] Excel VBA problem

Gustav Brock Gustav at cactus.dk
Mon May 25 07:31:17 CDT 2009


Hi Stephen and Max

I've learned that you should use WorkSheet for Sheet when dealing with WorkSheets.

/gustav


>>> max.wanadoo at gmail.com 25-05-2009 14:17 >>>
Is this :-

Sheets(i).Copy _
                     Before:=Workbooks(newFN).Sheets(1)   

Saying:-


Copy from sheet (i) to new work sheet and position before .Sheets(1)?

Can you do that?  Is there anything before sheet(1)
Or have I misunderstood

Max






More information about the dba-Tech mailing list