I have a subroutine that defines a range called "place" as follows
Sub mySub(StartAddr As String, myValue as Integer)
Dim place As Range
Set place = Worksheets("Sheet1").range(StartAddr)
myValue = place(1,-4).Value ' is this off the edge of Sheet1?
End Sub
The StartAddr parameter takes a text range description such as "R5" or
"Y2" or something like that. However if the value "B5" is passed into
this subroutine, then an exception will be raised since it is trying
to reference a value that is 4 places to the left of the B column.
Is there some kind of test that I can make on
place(1,-4)
to make sure that such a range is going to be a valid cell reference
without raising an exception?