On Sun, 5 Aug 2007 07:54:00 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

I know that the OP said "any selected row", and indeed, if he has entire row
selected when he runs your macro, it works as he desires. As such, it fits
the bill exactly!

To explain why I did it the way I did: I kind of presumed that often people
don't say what they mean here in the forums, and that they might have just a
single cell selected in a row - in which case, the code I tossed together
would make up for a little laxness on the part of the end user.

Heiku: now you have 2 versions to choose from and an explanation of the
differences between the two. Dallman's is superior to mine in that if you
know you'll always select the entire row, it does not have to use the
overhead mine does to achieve the same result.


Hello,

You were correct; I usually do not have the *entire row* selected when
I would like this macro to run.

Your script runs perfectly, and I appreciate your help.

Best regards,

Heiko