P
Phil H
Need to modify this maco to not count hidden rows. For example if seven rows
of ten rows in question are hidden, I need the macro to count only the three
visible on screen.
Also, if no rows were hidden, and all ten were selected (highlighted), the
macro should count ten.
In other words, it should count only what is selected/visible on screen.
Sub CountHighlightedRows()
MsgBox "Rows Selected: " & Selection.Rows.Count
End Sub
of ten rows in question are hidden, I need the macro to count only the three
visible on screen.
Also, if no rows were hidden, and all ten were selected (highlighted), the
macro should count ten.
In other words, it should count only what is selected/visible on screen.
Sub CountHighlightedRows()
MsgBox "Rows Selected: " & Selection.Rows.Count
End Sub