Selection.Name = "myRange"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jo" wrote in message
...
Hi
I wish to name a range using VB, the range would be the
selected cells. The selected cells will vary so I cannot
define e.g. A1:B4. Ideally
Range (selected cells).name = my range
Thanks for any help
Jo