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

--
Message posted from http://www.ExcelForum.com

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]


--
Regards
Frank Kabel
Frankfurt, Germany


Hi,

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

Thank you for your help.

Regards,
Xlund.


---
Message posted from http://www.ExcelForum.com/

Thank you Frank

--
Message posted from http://www.ExcelForum.com

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)

"Xlund " wrote in message
...
Thank you Frank!


---
Message posted from http://www.ExcelForum.com/

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

On 4/15/04 23:17, in article , "Xlund "
wrote:

Hi,

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

Thank you for your help.

Regards,
Xlund.

---
Message posted from http://www.ExcelForum.com/