Formula R1C1 reference a column

**Journeyman3000** · 02-13-2014, 07:35 PM

Hi all

i am trying to automatically enter a formular into a cell.

Please Login or Register  to view this content.

This works just find to calculate two cells along a row. I need to calculate a cell along a row, and the cell directly above the cell in which the formula is entered.

It might look something like this:

Please Login or Register  to view this content.

Of course, thats not going to work.

How do I reference a new row in this vba function.

Cheers

**MrShorty** · 02-13-2014, 08:08 PM

For a basic overview of how R1C1 notation works, read through the section here: http://office.microsoft.com/en-us/ex...es_in_formulas
Note that, just as you use brackets to contain relative references for columns (C[-8]), you use the same notation for relative references to rows. R[-1] refers to the row immediately above. So =SUM(RC[-8],R[-1]C) adds the value from the cell in the same row 8 columns to the left with the value in the same column one row above.