I don't know why Nigel, but that didn't work. i did not receive an
error msg, but it didn't paste the variable value into the new cell
either.

i have no idea what to do.

i thank you for your time and appreciate any other suggestions though.

thanks again,
jasonk


On Wed, 15 Mar 2006 07:59:22 -0000, "Nigel"
wrote:

The copy / paste method requires the target area to be the same size as the
source. So assign the source to a variable and directly place this in the
offset column ........

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