Thread: Copy a Sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Copy a Sheet

Sheets("master").Copy After:=Sheets(Sheets.count)

--
Regards,
Tom Ogilvy

"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?