Works great. Thanks, Luke.

"Luke M" wrote:

Sub HowMany()
MsgBox Selection.Rows.Count
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil H" wrote:

I am highlighting rows beyond what I see on screen. Can someone give me a
macro that counts the number of highlighted rows.

I'm guessing, then, that you will never have selections composed of
non-contiguous areas. For future consideration, you should really mention
such things in your questions when you ask them... the more information you
give about your set up and what you want to do, the better able we are to
give you solutions that do what you are looking for.

--
Rick (MVP - Excel)


"Phil H" wrote in message
...
Works great. Thanks, Luke.

"Luke M" wrote:

Sub HowMany()
MsgBox Selection.Rows.Count
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil H" wrote:

I am highlighting rows beyond what I see on screen. Can someone give
me a
macro that counts the number of highlighted rows.