What is the advantage of A1 or R1C1 Notation, R1C1 style is it making the macro speedy or same. i will try to learn if it makes the macro speed. i am interested to know A1 is speedy or R1C1 is speedy for base one macro.
In Cell A1 Formula R1C1 Formula A1 =B2 =R[1]C[1] A2 =B2+1 =RC[1]+1 A3 =A2+1 =R[-1]C+1 B4 =$A$3+1 =R3C1+1 C5 =B$4+1 =R4C[-1]+1 D6 =$C5+1 =R[-1]C3+1 A6 =SUM(A1:A5) =SUM(R[-5]C:R[-1]C)
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:
whereas with R1C1 notation I can do it in one step:Dim rngLoop As Range For Each rngLoop In Range("A1:A10").Cells rngLoop.Formula = "=" & rngLoop.Offset(0,1).Address Next rngLoop
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.Range("A1:A10").FormulaR1C1 = "=RC[1]"
Last edited by Andrew-R; 02-08-2013 at 12:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
nur2544 
Register To Reply
Bookmarks