One way:

Selection.Name = "my_range"

In article ,
"Jo" wrote:

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