pasting a value to a merged cell

[Nelson]

Hello,

I'm trying to copy the value of a calculated cell from
one worksheet into a merged cell into another worksheet.
In XP it works fine, but in 2000 I get the "Cannot
change part of a merged cell". When I try to run a macro
to do the same things, I get the message "Run-time
error '1004'". Any idea how to solve this problem?

Thanks in advance

 

[Norman Harker]

Hi Nelson!

Track down the merged cell

Format > Cells > Alignment
Remove check from "merged"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.