Excel macro: Add data to existing named range

Question

I have a named range "ABC", range is ("A1", "A3", "A5"). Now I need to use Macro to extend the range to ("A1", "A3", "A5", "A7"), that is, adding "A7" to the existing named range "ABC".

Any ideas to solve this problem?

Thanks in advance!

Tim Williams · Accepted Answer · 2014-03-07 07:16:47Z

3

Application.Union(Range("BLAH"), Range("A7")).Name = "BLAH"

answered Mar 7, 2014 at 7:16

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Karl-Henrik Over a year ago

Addendum if he would like to add a his current selection to his named range Application.Union(Range("ABC"), Selection).Name = "ABC"

user2774993 Over a year ago

Thanks! This is what I wanted.@Tim Williams

Mayur Dhingra Over a year ago

It is continuously giving this error - Method Union of Object _Application failed.

Collectives™ on Stack Overflow

Excel macro: Add data to existing named range

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related