With a lot of help from you guys I have a macro that performs these 2 tasks:
1. Adds text to a named range and then sorts the range alphabetically
2. Adds the same text to a table
What I now need to do is be able to reverse the procedure and be able to select and item from the named range and remove it from the range and table, then resize the range and table size accordingly.
I have attached an example sheet showing the existing function to help explain what I am trying to achieve, hope this makes sense let me know if not!
Bookmarks