View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Revenue Revenue is offline
external usenet poster
 
Posts: 23
Default 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