"Cannot Change Part of a Merged Cell" When updating link using mac

Hello Madhava,

When referencing merge cells, you must refer to the Leftmost or Upper Left Cell of the range. Referencing any other cell in the merged range will give you this error.

Example:
Range("A1:J1") is merged.

Range("A1").Value = "This is a test."
This works.

Range("B1").Value = "This is a test."

This will generate the error eventhough cell "B1" is a part of the Range("A1:J1").
This happens because the system references the merged range only by the Leftmost ot Upper Left cell in the range.

Check your code and formulas that address merged cells and be sure they are addressing the range correctly.