Copy a Sheet
 

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?

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?

Copy a Sheet
 

How about a message box to rename the sheet that is created?

"Tom Ogilvy" wrote:

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?

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