Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

If the Range object consists of more than one cell, the Row property returns the row number of the first row in the range

Sub rowRange()     MsgBox Sheets("Sheet1").range("A1:F3").row End Sub