how do i copy and paste a formula from one sheet to another

[tonywatsonhelp]

Hi everyone,
I think i'm having a friday,

All i'm trying to do is copy a range of cell and get the formulas not the values
but for some reason i get REf#

Group.Range("O154:O161").SpecialCells(xlCellTypeVisible).Copy 'Rate
Sheets("32 Invasive Species").Range("AJ143").PasteSpecial xlPasteformulas

so for example O154 might be a simple formula like =M11 but i get error?
not sure this has happened before?

please help if you can i must be doing something so obviouse
thanks
Tony

 

[tonywatsonhelp]

Hi everyone,
dont worry, i've worked it out,
basicly, im an idiot lol!

 

[Joe4]

so for example O154 might be a simple formula like =M11 but i get error?

That is to be expected. Do the math, and you can see this.

If in cell O154 you have the formula =M11, the that formula is pulling the value from two columns to the left and 143 row above that cell (154-11=143).
However, if you are copy/pasting that formula to cell AJ143, you cannot go up 143 rows from there, as that would be row 0!