R1C1

Hello Suraj,

Hope you enjoyed your Microsoft Excel VBA course with Best STL.

Thank you for your question regarding the use of R1C1.

Did you know that under the hood Excel always uses the R1C1 style... whenever you create a macro you will notice that the code is in the R1C1 style and it is always useful if you know how to read this notation.

When creating code, you don't always have to use this style, but, in many cases it will decrease the amount of code you write. Here are a few reasons why you may want to use this style:

1) It is easier to enter many formulas using this style thus making the formulas more efficient in VBA. You can enter the same formula in an entire range of data in a single sentence.

2) Conditional formatting requires this style in order to work reliably.

3) Array formulas require this style.

As you are no doubt intending to progress with Excel VBA it will be beneficial if you buy yourself a book on the subject. A website to find books for this is MrExcel.com

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer