help in moving a range of formulas

[Brenda]

Thanks for helping.
I have a range of formulas say a1 to b3.
I want to move these cells with the formulas and keep the same results
to say cell c1

I tried several different ways but when I do any paste I get either
the wrong answers of a REF! error.
I tried "copy" then "paste special" with no luck.

Thanks Much
Brenda

 

[Max]

Try Cut > Paste

 

[Roger Govier]

Hi Brenda


Depending upon what else you have in column A and B, and whether it would
have any other effect upon your sheet, then maybe, mark columns A and B,
right click, Insert.

Regards

Roger Govier

 

[Brenda]

Thanks for the help Guys.
Got it,
Brenda