Hi,
First up, you say "Columns A, C and D", do you mean "Columns A, *B,* C
and D"?
I would remove the merged cells b/c they can cause a range of problems
& use the option to "centre across selection" which can be found under
[format - cells - alignment] & then the "horizontal" dropdown.
Sorry, I can't replicate this issue - my equations go up by 1, can you
please provide an example of the formulae that are being copied?
(If no one else responds in the mean time I'll check it out after sleep
& work.)
A potential solution involves the use of the "offset" function.
hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=506730