PDA

View Full Version : Help RC FORMULA STYLE



aligahk06
11-05-2009, 03:18 AM
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

MaximS
11-05-2009, 04:49 AM
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.

mdmackillop
11-05-2009, 04:20 PM
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

aligahk06
11-06-2009, 01:00 AM
Cam u suggest me any link or details that elaborate all the col and row in RC referencing format.