How to interpret cell references from formula to vba?

[Xlund]

Hi,

I have recorded a few macros successfully but now have to make som
adjustements in the vba code. Specifically, I need to change the cel
reference from A2 to C5 in my formula. In my VBA code, A2 appears a
RC[-26]. What would the equivalent of C5 be in vba code format? T
avoid future such problems, what is the rule/logic behind th
translation of cell references of formulas into vba, i.e. why does A
equal RC[-26]?

Thank you for your help.

Regards,
Xlund

 

[Frank Kabel]

Hi
for more explanantion about the R1C1 Reference styl you may see the
Excel help (topic 'R1C1 reference')

In your case you have a relative reference:
RC[-26]]
translates to current row (R) and the column 26 positions to the left
(C[-26]) of the cell you insertert this formula

So in your case try
R[-3]C[-24]

 

[Xlund]

Thank you Frank

 

[Bob Phillips]

You can also refer directly

RC3

gets the C column on the current row.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[TH]

Your Macro recorded an R1C1 relative format. You don't have to use this. You
can reference cells in several ways:

Cell A1 = Range("A1") = ["a1"] = cells(1,1)

Also, Range("A1:G20") is valid.

There are other ways. Goto HELP and type "referring to cells".

Also, the above references are to the active worksheet. If you want to refer
to a sheet that is not the active sheet you must say so as in:

Worksheets("Sheet1").Range("A1")

TH