MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Cell referencing

  Asked By: Lorraine    Date: Oct 07    Category: MS Office    Views: 631

I am rather new to VBA with excel and
am wondering about cell referencing. I recorded a macro and in one of
the cells I clicked on it presented the formula in the code. The
notation was different then anything I had seen before, R[]C[]
notation. It seems simple in that R[10]C[4] should reference the cell
in row 10 column 4 but it doesn't always seem to match up. Is it a
relative referencing? Or an absolute?



1 Answer Found

Answer #1    Answered By: Albert Ellis     Answered On: Oct 07

R[10]C[4] is a relative reference  for R1C1 style

R10C4 is an abolute reference for R1C1 style

Didn't find what you were looking for? Find more on Cell referencing Or get search suggestion and latest updates.