If you're doing it manually (ie not through VBA) then just hit cntrl-F3 and
it will give you a "Define Name" window. here just choose a name and then
it's like making a graph, just click where you want to define your range.

Cheers,

Scott

"T. Jenkins" wrote:


I'm trying to define a named range based on the selection. The help covers
the following simple scenario.

ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:= _
"=Sheet1!R1C1"

Can someone please show me how to change this based on the currently
selected range?

Thanks,
Todd