How do I assign a selected range to a name in VBA that updates everytime macro is run

**Sandles66** · 10-01-2012, 05:02 AM

When I record a macro to set a name to a selection it sets the name to a A1C4 type reference (or whatever I have selected). Next time I run teh macro it sets the name to the same range and not the new selction.
I can't find the method that extracts the reference from the selection and can be assigned to name.

**Sindhus** · 10-01-2012, 05:06 AM

The same name cannot be added to two ranges. In the code, you have to edit the reference of the named range.

Please Login or Register  to view this content.

**Sandles66** · 10-01-2012, 05:08 AM

I don't have the reference, I just have a selection

**Sindhus** · 10-01-2012, 05:16 AM

I understand from your post that you had named a range using vba code. And you are trying to add a different range with the same name. I gave the solution for that only. Let me know if my understand is wrong.

**Sandles66** · 10-05-2012, 09:57 PM

I found the answer thanks

Please Login or Register  to view this content.

What I was struggling with was assinging a range to a name that was different each time the macro ran

How do I assign a selected range to a name in VBA that updates everytime macro is run

LinkBack

Thread Tools

Rate This Thread

Display

How do I assign a selected range to a name in VBA that updates everytime macro is run

Re: How do I assign a selected range to a name in VBA that updates everytime macro is run

Re: How do I assign a selected range to a name in VBA that updates everytime macro is run

Re: How do I assign a selected range to a name in VBA that updates everytime macro is run

Re: How do I assign a selected range to a name in VBA that updates everytime macro is run

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions