Create Named Range in VBA

M

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
 
N

Norman Jones

Hi Michael,

Try:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Accessing a macro created named range 7
InputBox to name a range 2
Variable length named ranges 2
Would like to create customized named range 2
output data on range 1
VLookup in VBA Help Needed 9
Creating named range in VBA problem 3

Top