General information
Category:
COM/DCOM and OLE Automation
>Using your example, Tamar, I also added the optional Count parameter to create nPages -1 copies of Page 1. Now I get a syntax error at that line...
> ***********************************************
> .Sheets("Page 01").Copy(,.Sheets[1],nPages-1)
> ***********************************************
I don't see an optional Count parameter for Copy. The syntax I'm seeing for the Copy method has only the two parameters I mentioned - Before and After - and you can only pass one of them.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only