Copy a Sheet
"Judd Jones" wrote in message
...
I am trying to use the following code to copy a master sheet after the
last
sheet in the workbook.
Sheets("master").Select
Sheets("master").Copy After:=Sheets(6)
The last part of the above is giving me the trouble. What should the
After:=
statement be?
Sheets("Master").Copy After:=Sheets(Sheets.Count) 'copy it
Sheets(Sheets.Count).Name = "Master-2" 'rename it
something useful
|