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/