relative/absolute address - newbie Q.

[DonAndress]

Hello.

I am having a really hard time understanding absolute and relative ways of addressing cells.

Could you please help me undestand it or at least change the address below, as I have no idea how they work?
In my project I need absolute addresses.

Sheets("sheet2").Select
    Range("A1").Select
    val = "=sheet2!R[38]C[-7]-sheet2!R[50]C[-7]"
Sheets("sheet1").Select
    Range("J3").Select
    Selection.Value = val
    Selection.NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)"
    Application.CutCopyMode = False

Of course I'm refering to "val" calculations so is there any possibility to change addresses to any understadable format?

 

[mikerickson]

Your asking about relative referencing in VBA suggest that you might want to look at the .Offset property.

 

[DonAndress]

Thank you, Cindy.
My project works smoothly now



mikerickson, I sure will, thanks.