Hi Stephane

not sure what you mean here, do you want to
1) take the value (which is derived from a formula in A1) and put it in A4
i.e. you have in A1 =B1-B2 and this gives an answer of 5, now you want the 5
(but not the formula in A4)
if so, then copy (or cut) A1, click in A4 and choose edit / paste special -
values

2) do you want to put the same value in A4, which is in A1 so that if A1
changes the value in A4 also changes
e.g. in A1 you have 7, you want the 7 also to appear in A4. If you change
the A1 7 to 5, then A4 should change to 5.
if so, and you don't want a formula in A4 you will need to use a
worksheet_change event (ie VBA code) - please let us know if this is what
you're after and we'll come up with the code for you.

something else entirely, if so, could you please provide a few more details.

Cheers
JulieD

"Stephane" wrote in message
...
Hi,

I need to move the content of a cell by x number of columns (i.e. A1 to
A4)
but I cannot have a formula in the destination cell. How can I do that
easily?

thanks,