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 is my named range.![]()
mRange2.Value2 = vbNullString
Thanks
Bookmarks