Copying and Pasting a Formula Using a Macro.

[Ste_Moore01]

Hi guys,

I'm trying to copy a formula from one cell to another using a macro.

By copying the formula, I mean the exact formula and not just copying the cell and pasting so the formula changes for your destination cell. I've tried recording a macro and it won't allow me to do it that way.

Is there any way to do this?

 

[RAM]

You need to anchor the cell references in the original formula, i.e. A1 will be $A$1.

The fastest way to do this is selecting the cell with the formula, mark the cell references in the Formula Bar and hit F4.

HTH

RAM

 

[Ste_Moore01]

Thanks that's worked perfectly!

 

[RAM]

You can mark the whole formula in the Formula Bar in a case like this one. In other cases when you need only one cell ref anchored, i.e. A1, not A1+A2, then you mark only A1 in the Formula Bar and hit F4. Hitting F4 more than one time gives you different anchor positions as if you want to anchor the row or the column: $A1 will anchor Column A. A$1 will anchor row 1 in Column A. $A$1 will anchor cell A1

Book12
	A	B	C	D
1	3	1	2
2	4		3
3	5		4
4	6		5
5	7		6
6	8		7
7	9		8
8	10		9
9	11		10
10	12		11
11
12
Sheet1

RAM