Posted to microsoft.public.excel.programming

Ron McCormick[_2_] Ron McCormick[_2_] is offline

external usenet poster

Posts: 21

Copyinng & Renaming Worksheets

I am wanting to copy a worksheet and then rename it with a
suffix that is a named range on the worksheet.

viz. something like
Sheets("Worksheet(2)").Name = "Worksheet ("& Region &")"
where region is thenamed range. What is the code required
for this.

TIA
Ron

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
Renaming worksheets	Teeny	Excel Discussion (Misc queries)	8	August 18th 09 10:21 PM
Renaming worksheets	James	Excel Worksheet Functions	0	May 12th 09 11:45 PM
RENAMING WORKSHEETS	LEOPARDSHIDEAWAY	Excel Worksheet Functions	1	July 26th 07 10:27 PM
Renaming worksheets	Mike Allen	Excel Discussion (Misc queries)	8	January 21st 07 02:15 AM
Renaming Worksheets	Steve Walford	Excel Worksheet Functions	3	April 1st 05 09:29 PM

All times are GMT +1. The time now is 12:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us