View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron McCormick[_2_] Ron McCormick[_2_] is offline
external usenet poster
 
Posts: 21
Default 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