Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Returns a count of the number of rows in a selection
Sub CountRows()
    Dim myCount As Integer
    myCount = Selection.Rows.Count
    MsgBox "This selection contains " & myCount & " row(s)", vbInformation, "Count Rows"
End Sub