Many thanks! Coincidentally I just finished reading a post of yours over at ExcelForum.

I'm hoping to use the concept of the "Splitter" macro to split pages based on the unique value in either the footer of each page or, e.g., a table cell (where I had it previously), and then save each new document based on that value using a variation of the code in my first post.

I'm certain it's easier said than done...