General information
Category:
COM/DCOM and OLE Automation
Hi again Tamar,
Further to my previous message, sheets placed before the copied sheet can be renamed as a workaround..
Just curious as to why I could not execute your code to place the sheets after.
Tks
>Right! I was confusing it with a similar WorkSheets method.. Sorry.
>
>However, even without the 3rd parameter I get a Syntax error from VFP. If I remove the comma in the Copy(,.sheets[1]) I get the expected results (the sheets are created before the copied sheet.
>
>
>>>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