ExcelBanter - naming a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - naming a range (https://www.excelbanter.com/excel-programming/302459-naming-range.html)

Jo[_6_]

naming a range

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

JE McGimpsey

naming a range

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

All times are GMT +1. The time now is 03:02 PM.