adding values to a range of cells

Hey All,

I have a spreadsheet im building which has a a range of values(Range(F14,BI69).

Now i have forgot apart of what i am calculating and need to add it on to each formula in those cells,

how can i run a macro to do it automatically and save me the time of doing it manually?

Cheers,
Mike

I have Cell different Absolute cell references for filling horizontally and vertical for my Chart.

example:
1 2 3 4 5 6
1
2
3
4
5
6

what i do is when i drag the formula down i Absolute refrence the cell with the 1 on the horizontal bar. IE if A1 is blank and the upper left corner, A2-$B$1, and then when i drag it horizontally it is $A$2-B1.