| File > Options > Formulas > [] R1C1 reference Style
Use the Macro recorder to get the code. Alt F T F then Alt R Enter Adding a formula will look like the following to cell AP9 =R[1]C[-21]+R[1]C If you turn it off you'll see the following: =U10+AP10 There seem to be places where your Macro might stop working if this Option is set but I need to research it more. R[1]C - goes down 1 row in the same column RC[1] - goes 1 column to the right on the same row |