How do I find out how many rows I have selected?
Jim, that is what I was getting ready to suggest as well.
Sub likeThis()
MsgBox = Selection.Count / 256
End Sub
Jim May wrote:
In the immediate window i entered:
? Selection.count/256 (256 for Excel 2003 and Prior)
Got me the right answer
Jim May
"ABR" wrote:
If I select a group of rows, and then add more groups of rows to the
selection by holding down CTRL, How can I find out the total number of rows
selected?
Is there a way of identifying how many items have been selected without
counting them yourself?
Thanks!
|