Pass a string to an address
I answered my question with this test:
Public Sub changerange()
Dim myStrg As String
Dim myrange As Range
myStrg = "A3"
Set myrange = Range("a1")
myrange.Select
Set myrange = Range("a2")
myrange.Select
Set myrange = Range(myStrg)
myrange.Select
End Sub
sometimes I have to go back to the basics, WAY back, that is
|