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.


--
Leith Ross


------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=478919