I do like the idea of a terror message!!
So, you were nearly there. The Named Range (SheetList) can be viewed by using CTRL F3. As for the rest, you used the wrong sort of tick (how naughty of you!!). It needs to be ' and not `. Also there was the odd ampersand missing.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you Glenn. Unfortunately I'm not sure the method for selecting a range will work for me. I need to find a way to create a defined range of sheets that can somehow include each new sheet my macro creates, so a dynamic range. I may just need to split my workbook into 4 separate workbooks based on the district, but ideally I could have this all in one sheet. So close!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
philubuster 
Register To Reply
Bookmarks