I am trying to create a macro that will add a value to an existing named range, sort the name alphabetically and then expand the named range to include the new value.
I have managed to get the data into the list, and sort the list alphabetically. The only part I am struggling with is expanding the named range. Can anybody help?
Here is the code so far:
Please Login or Register to view this content.
Bookmarks