'ActiveWorkbook.Names.Add Name:' how to make range variable?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Data is coming into a worksheet, and from a macro, I determine the range
using Selection.CurrentRegion.Select, I then .Add Name, but the macro is
setting the range. I want the range to change each time the macro is run.
 
Hard to say what the problem is without seeing your code.

Perhaps

Range("A1").CurrentRegion.Name = "Data1"
 

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

Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
InputBox to name a range 2
VBA set thick borders around non empty cells in range 0
Creating a range name from Selection.CurrentRegion.Select 2
Macro needs updated Range name addresses 3
Changing Name Range based on imported data 2
Ranges & Names 1
Name a range using cell contents 2

Back
Top