excel question

[vb_student]

Hello
I know this is not an excel forum but can you guys tell me if there is any difference between the reference in a cell of say =c22 and =c$22

[RobDog888]

This is the place!

$A$1 (absolute column and absolute row)
A$1 (relative column and absolute row)
$A1 (absolute column and relative row)
A1 (relative column and relative row)

[vb_student]

thanks robdog for the reply
what is the relative reference "relative" to?


i wanted to also set a breakpoint in VB, such that if a certain cell (C47) was accessed then the program would break execution there.

i have done a search in the program, have not come across any instances of accessing, my feeling is that the programmer has used temp variables through run through rows and columns and has accessed it in that manner.

[Br1an_g]

it is relative to the start or initial formula.

if you copy and paste the formula to another cell, it will update the formula in relation to the start cell.

hope that makes sense.

[vb_student]

thanks for the reply
so this only holds meaning if i do a copy paste operation of cells.
and if i have an absolute reference say $a$1 and i copy paste those cells, i will be referencing the same cell.
correct?

[Br1an_g]

yes, exactly right.

if you have an absolute reference it stays fixed even when you copy / paste or drag the formuula to adjacent cells.

[vb_student]

thanks dude
now i wont beintimidated by those $ signs