I assigned a name to a merged cell
.Name = "Location"
Range("Location").Value = "Multiple (see below)"
I need to use the value entered to trigger additional code.
Dim Choice as String
Choice = Report.Range("Location").Value
I keep getting a type mismatch error.
Any help would be appreciated