Hi,

I want to automatically clear cells across my workbook with VBA (to empty it). Certain cells are merged so the common approach of .clearcontents does't really work properly.

It seems that the following two approaches work correctly and I'm wondering if one should be used over the other:
mRange2.Value = ""
mRange2.Value2 = vbNullString
mRange2 is my named range.

Thanks