Re: $$Excel-Macros$$ Named Range to Dynamic with VBA

2011-08-30 Thread dguillett1
mc & "))" End If End If Next N End Sub From: Daniel Sent: Tuesday, August 30, 2011 4:34 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Named Range to Dynamic with VBA Hi, Be cautious with this macro and keep a copy of your workbook. Look at the attach

RE: $$Excel-Macros$$ Named Range to Dynamic with VBA

2011-08-30 Thread Daniel
Hi, Be cautious with this macro and keep a copy of your workbook. Look at the attached workbook in which there is an example of error. Sub test() Dim N As Name, Var As String, Tabl As Variant For Each N In ActiveWorkbook.Names If LCase(Left(N.RefersTo, 7)) <> "=offset" Th