Thread: Copy a Sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach Jef Gorbach is offline
external usenet poster
 
Posts: 59
Default 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