View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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!