VBA – Count the rows in a Selection
Written by
Reviewed by
Last updated on July 19, 2021
If you ever need to count the number of rows that were selected, use Selection.Rows.Count
Count Rows in a Selection
Public Sub CountMyRows()
MsgBox Selection.Rows.Count
End SubIf you ever need to count the number of Columns that were selected, use Selection.Columns.Count
Count Columns in a Selection
Public Sub CountMyColumns()
MsgBox Selection.Columns.Count
End SubVBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
