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