Hi Jason,
Is there a real need for the cells on the right to be merged?
I don't like merged cells but thought I'd do a couple of quick Googles
& see what others think, eg
http://tinyurl.com/g7evk
I came across the below and think Barry Katcher's explanation is very
apt & I agree with his suggestion:
"the technical explanation of what is happening is this: merged cells
suck! They're much more trouble than they're worth. Before trying to
figure out code to circumvent your problems, you might want to try
this: unmerge your cells, and try formatting them to
FormatCellsAlignmentHorizontalCenter Across Selection. Practically
the same results, without the hassle. "
http://www.mrexcel.com/archive2/72100/83644.htm
It seems the general consensus is to remove any merged cell formatting
& with it your problems will disappear. Probably not what you wnat to
hear but I hope it helps,
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=522524