Unhide sheet, copy and rename new sheets from list, rehide sheet
Hi Howard,
Am Sat, 12 Oct 2013 05:22:23 -0700 (PDT) schrieb Howard:
I tried to reset the range to this but the Define Name Box would not take it.
Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row)
try:
=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A))
for MyNewList
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|