?? - it should do

If you did not get an error then it is probably working, but you either have
not selected an active cell with something in it or the target cell format
is hiding the value.

Paste the code section you are using......

--
Cheers
Nigel



"JasonK" wrote in message
...

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