Sheets("Sheet 1").Copy After:=Sheets(Sheets.Count)


The default sheet name is "Sheet1" so I assume you changed the sheet name to
have a space before the "1".

--
Jim
"comotoman" wrote
in message ...
|
| my line is:
| Sheets("Sheet 1").Copy After:=Sheets(3)
|
| This is part of a sheet copy macro, I need it to copy "sheet 1" to the
| end, not after sheets(3). The workbook can have 40+sheets. Any help
| would be great!!!
|
|
| --
| comotoman
| ------------------------------------------------------------------------
| comotoman's Profile:
http://www.excelforum.com/member.php...o&userid=27292
| View this thread: http://www.excelforum.com/showthread...hreadid=474121
|