Posted to microsoft.public.excel.programming

Cathy W[_2_] Cathy W[_2_] is offline

external usenet poster

Posts: 30

Rename a worksheet after copy...

Hello. I am using the following code to copy a worksheet named DOS5 into a
workbook that already has a sheet called DOS5. When it gets copied I would
like to rename it to the next sequential sheet number (ie: DOS6). Can
someone help?

bk.Sheets("DOS5").Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Cou nt)

Thanks,
Cathy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro: Copy a worksheet and rename it to a specified value	mitch	Excel Discussion (Misc queries)	2	February 16th 09 05:43 PM
Copy worksheet and rename sheet	Ernst - EXE Graphics	Excel Discussion (Misc queries)	4	July 25th 08 01:18 PM
Worksheet copy with rename	Doug Broad[_4_]	Excel Programming	6	March 3rd 06 02:57 PM
Copy/Paste Worksheet to last and rename with input box for value.	Dave Peterson[_3_]	Excel Programming	2	September 7th 04 08:59 PM
Copy worksheet from multiple files in one DIR to another DIR & rename	Mike Taylor	Excel Programming	1	July 13th 03 03:28 PM

All times are GMT +1. The time now is 11:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us