MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to Add Name Referring to Current Selection


Posted by Ben O. on October 27, 2000 9:25 AM

This sounds simple but I can't figure it out. I need to add a name that refers to my currently-selected range.

ActiveWorkbook.Names.Add Name:="Data", RefersToR1C1:=??????


-Ben


Posted by Ben O. on October 27, 2000 11:28 AM

Nevermind, I figured it out. (n/t)

Posted by Fred on October 27, 2000 4:04 PM

Re: Nevermind, I figured it out. (n/t)

Well, Ben - what *was* the answer? : This sounds simple but I can't figure it out. I need to add a name that refers to my currently-selected range. : ActiveWorkbook.Names.Add Name:="Data", RefersToR1C1:=?????? :

Posted by Ben O. on October 28, 2000 2:27 PM

Re: Nevermind, I figured it out. (n/t)

The spreadsheet is at work so I can't be sure that it's exactly this, but it's close:

Set NewName = Selection
ActiveWorkbook.Names.Add Name:="Data", RefersToR1C1:=NewName

-Ben Well, Ben - what *was* the answer?