Copy to end

[comotoman]

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!!!

[Jim Rech]

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" <[email protected]> wrote
in message news:[email protected]...
|
| 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
|

[Tom Ogilvy]

Sheets("Sheet 1").Copy After:=Sheets(sheets.count)

--
Regards,
Tom Ogilvy

"comotoman" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>