Nigel,
you're macro works great stand alone. you were right. the merged cells
are the problem. for this worksheet, i need them though.

is it possible to select the cell that is 5 cells over? or can i only
reference it? if i can select it, then i can paste, and that seems to
work at least manually, outside a macro.

thanks again,
jasonk


Dim x As Variant
x = ActiveCell.Value
ActiveCell.Offset(0, 5) = x







On Wed, 15 Mar 2006 02:33:03 -0600, broro183
wrote:


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...