Dynamic Range Naming for VBA

  • Thread starter Thread starter mrtoemoss
  • Start date Start date
M

mrtoemoss

I've searched through the many threads that deal with naming ranges but have
not
come a solution to my problem, thanks for your patience with another VBA
newbie.

In the code below, I correctly select the range which I would like to name
"MyRange"
What must I add to the code to name this selected range?

Worksheets("TempSheet").Range("A2:A" & Sheets.Count - 4).Select

Thanks for your help.
 
I've searched through the many threads that deal with naming ranges but have
not
come a solution to my problem, thanks for your patience with another VBA
newbie.

In the code below, I correctly select the range which I would like to name
"MyRange"
What must I add to the code to name this selected range?

Worksheets("TempSheet").Range("A2:A" & Sheets.Count - 4).Select

Thanks for your help.
Click to expand...

Don't select it. Name it with

Worksheets("TempSheet").Range("A2:A" & Sheets.Count - 4).Name = "MyRange"

Watch for word wrap

Alan Beban
 
Thanks Alan, I was really trying to complicate things unnecessarily.
 
You must log in or register to reply here.

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

Dynamic Name Range in VBA? 1
Macro won't run correctly when a worksheet is hidden 0
Search for LIKE 4
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Unprotect Sheet for the duration of a script 7
Conditional formatting on a dynamic range - workaround 1
macro to select a range from a set cell to a specified cell 6
Can Vba workout if a selection is part of a group? 0

Back
Top