Thanks oeldere and HaHoBe. Music to my ears, but wish I knew that a month ago! Need to take a course on VBA! Thanks for the code to skip over sheets not visible, which now means using one macro for all scenarios!