I'm new to this site, so please be patient!
The problem I am trying to solve is to that I want to move worksheets (using a simple macro) in my workbook, with the name of the worksheets to be moved specified by a named range (say, "sheets_to_exclude"). To be clear, the range contains the names of each sheet. The range is also dynamic, as the sheets to be moved are to be determined by a set of inputs which can change.
I am not sure how to use the Sheets() object with a named range , and also am not sure if the dynamic range will cause issues. Any help welcome, I am sure it's an easy answer!
Thanks in advance!