What does the Excel range.Rows property really do?
Range.Rows and Range.Columns return essentially the same Range except for the fact that the new Range has a flag which indicates that it represents Rows or Columns. This is necessary for some Excel properties such as Range.Count and Range.Hidden and for some methods such as Range.AutoFit(): Range.Rows.Count returns the number of rows in Range. Range.Columns.Count … Read more