[Peter T. Daniels]

On Aug 2, 1:04 am, Venky62 wrote:
Phew! I feel happy that it suits your requirement.

The "Option Explicit" statement is part of VBA options. It simply means
that the code has to declare all variables. It prevents error in
programming.

Does that mean I'm supposed to include it somewhere within the text?

Yes, when I at last realized what you were really looking for, it was

What was unclear about the original formulation?

simply a matter of connecting the two macros by a few lines of code. I
could have included all the code in one macro, but this is a better way
of doing it. Any programmer who looks at the code will be able to follow
it more easily.

Peter T. Daniels;492987 Wrote:

It works, and I thank you for providing exactly what I asked for
originally! Thank you very much.

I was nonplussed by the line "option explicit" at the top, and also by
the fact that it appears to be two separate macros, but somehow the
single keyboard shortcut works with both of them.