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
>