Macro needs updated Range name addresses
ActiveWorkbook.Names.Add Name:="Current", RefersTo:=Selection.Address
Before I saw this, I actually got it to work without the .address
after selection. Is there a danger in not putting the .address in
there?
Or, is that the difference you meant is that way would cause a
workbook level names?
Thanks,
Bruce
|