I have a range name that's called "PlanMonth1" and I'd like to reference it
within my code.

What I want to do is something like this:

Debug.Print "Range Value = ", Range("PlanMonth" & ActiveCell.Offset(0,
-1).Value).Value


but I'm getting an error. What am I doing wrong?

Thanks

Method Range of object worksheet failed.