What is the advantage of A1 or R1C1 Notation ?

R1C1 notation makes it easier to place formula by macros, as it saves you constantly having to recalculate the addresses.

For example, if I want to make the cells in A1:A10 contain a formula pointing one cell to the right of them then with 'normal' notation I could do something like this:

Please Login or Register  to view this content.

whereas with R1C1 notation I can do it in one step:

Please Login or Register  to view this content.

Edited to add: Actually, that was a really bad example, as you can do the same thing with standard notation. I will think of a better answer, really.