Thread: Unhide sheet, copy and rename new sheets from list, rehide sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Unhide sheet, copy and rename new sheets from list, rehide sheet
Hallo Howard,

Am Sat, 12 Oct 2013 13:29:41 +0200 schrieb Claus Busch:

For Each rngC In .Range("MyNewList")

Change to:
For Each rngC In Sheets("Sheet1").Range("MyNewList")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote