Thanks, Jim.

I've been using VBA for about 4 years, now, and have recently got to the
point where I can (usually) write code fairly quickly to do what I want. OK,
it may not be the most elegant or the quickest, but it works! But
occasionally something really simple like this completely stumps me! As you
say, very often it's the simplest solution that works. Sometimes we just
can't see the wood for the trees.

Nothing to feel stupid about. Sometimes the simplest fixes are the
hardest
to see. We expect everything to be complicated and overlook the simple
things.

Welcome to the club!
--
Best wishes,

Jim