Displaying range value when range name is concatenated
Sub missive()
s = InputBox("enter range name: ")
MsgBox (Range(s).Address)
End Sub
--
Gary's Student
"Barb Reinhardt" wrote:
I have this in cell A1:
="PlanMonth" & row()
I'd like to display the range name that matches "PlanMonth1". How do I do
that?
|