How do I edit a Named Range using macro's

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

Guest

Defining a Named Range assigns a name to the range. The range can be
manually changed based on a selection. However, when you try to record the
steps up update the range of an existing Name, the range is hardcoded in the
macro. Running the macro does not update the Named range.

I am using the Named ranges in other macro's, e.g., selecting and copying
data in the range, creating a pivot table based on the range.
 
Selection.Name = "ABCD"

would update the refersto property of the named range "ABCD". If ABCD did
not exist, it would be created.
 
Thanks a million. I spent nearly 20 hours trying complicated fixes, none of
them worked. This was a simple fix.
 
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

Conditional formatting on a dynamic range - workaround 1
Set non-continuous PrintArea via Function / Name 0
Repeat the macro using different ranges 1
Stop Macro running when I save the workbook 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro to copy value in field and insert it into filter 2
How do I have a cell value define a dynamic named range? 15
Pivot Table Macro 1

Back
Top