How is starting and ending row number of a Range obtained?
- by Robert Kerr
Given a user-selected Range, what is the simplest way to determine the starting row number, and ending row number?
Range.Address returns a string containing any number of possible formats. There has to be something simpler.
Desired:
Dim oRange As Range
Dim startRow As Integer
Dim endRow As Integer
oRange = Range("A1:X50")
startRow = oRange.Address.StartRow
endRow = oRange.Address.EndRow
of course, those properties do not exist.
I want to do the same to return column letters.
