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)
VBA
Last Comment
Conernesto
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
C appears to be the start column. What does the R stand for?
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
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.