Access VBA code meaning
I have the below piece of code in a module. The code is run from Access and it's applied to an Excel spreadsheet. Can yo please describe what below code means as I may need to make a change?
.Cells(44, C).Value = "=R[1]C-SUM(R[-8]C:R[-1]C)
.Cells(44, C).Value = "=R[1]C-SUM(R[-8]C:R[-1]C)
It's putting a formula in a cell, which cell is hard to determine without knowing what C is or if there is a further range reference.
The formula itself can be interpreted as such:
Subtract the sum of the 8 cells above the destination cell from the value in the cell below the destination cell.
For example if the formula was to go in cell H17 it would look like this:
=H18-SUM(H9:H16)
R[1]C
R stands for Rows
C stands for Columns
in this form of notation the values are the offset from the current cell. This is often referred to as R1C1 notation, see: https://bettersolutions.co
R stands for Rows
C stands for Columns
in this form of notation the values are the offset from the current cell. This is often referred to as R1C1 notation, see: https://bettersolutions.co
Premium Content
You need an Expert Office subscription to comment.Start Free Trial