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
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