I am using

name = Range("A1").Value

where cell "A1" is merged horizontally with "B1"

and where name is a string variable

This generates an error.

Is there way to get this value?

Thanks,

Dennis