Conernesto
asked on
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 m/excel/fo rmulas/cel l-referenc es-a1-r1c1 -notation. htm
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
ASKER
Thank you very much.
Conernesto
As Daniel has explained the R and C in the formula refer to rows and columns, but the R here,
.Cells(44, C).Value =
is a variable and represents the column the formula will be placed in.
ASKER
Great. Thank you.
ASKER