Create Named Range in VBA

[michael.a7]

I would like to highlight a range of cells in my worksheet and then run a macro that will then create a Named Range using those highlighted 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,
Michael

[Norman Jones]

Hi Michael,

Try:

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


---
Regards,
Norman


"michael.a7" <[email protected]> wrote
in message news:[email protected]...
>
> I would like to highlight a range of cells in my worksheet and then run
> a macro that will then create a Named Range using those highlighted
> 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,
> Michael
>
>
> --
> michael.a7
> ------------------------------------------------------------------------
> michael.a7's Profile:
> http://www.excelforum.com/member.php...o&userid=33027
> View this thread: http://www.excelforum.com/showthread...hreadid=550149
>

[michael.a7]

Thanks Norman