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.
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.