Thanks Roy. That indeed does the job! I am just moving the sheets after a tab called "Exclude>>", so have just used
One more question (not sure if I need to post this as a new thread?), but what do I need to add to your code to first check that the range is NOT empty/invalid? As there is a possibility (determined by user inputs) that the dynamic range ("sheets_to_exclude") does not contain any values (i.e. the dynamic range name returns #Ref, and so the VBA code you provided does not work.. so I first need to check that the range is valid and then loop though if it is).
Thank you so much.
Carim, good advice, but I wasnt sure how to use record macro to record what I need in this instance, as it involved range names,