Dear All,
Can anybody clear my concept regarding in vba code RC[-1],RC[-2] and so on.
I am confused and need help
Please assist ?
Rgds,
Aligahk06
Dear All,
Can anybody clear my concept regarding in vba code RC[-1],RC[-2] and so on.
I am confused and need help
Please assist ?
Rgds,
Aligahk06
RC is referencing to relative colum/row from the cell where the formula is inserted.
So RC[-1] will be A1 if insetred in B1 or B2 if starting point is in C2.
Other combinations can be like R[1]C[2] meaning plus one row and two columns etc.
If you omit the brackets, the reference is to the actual row and column
R2C4 = D2
You can also mix references
R2C[-1] = Row 2, column offset -1
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Cam u suggest me any link or details that elaborate all the col and row in RC referencing format.