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