Create Named Range in VBA

[michael.a7]

I would like to highlight a range of cells in my worksheet and then ru
a macro that will then create a Named Range using those highlighte
cells.

I suppose the VBA would be something like:
ThisWorkbook.Names.Add Name:="NewName", _
RefersTo:=

But I don't know what code is needed next. Can anyone help?

Many Thanks,
Michae

 

[Norman Jones]

Hi Michael,

Try:

'=============>>
Public Sub Tester()
Selection.Name = "YourName"
End Sub
'<<=============

 

[michael.a7]

Thanks Norman