You might be wondering whether you should take the time to learn about these 2 topics. More particularly, my purpose with this blog post is to provide you with all the information you need to understand and use both the R1C1-style notation and the Range.FormulaR1C1 property. My focus is the Range.FormulaR1C1 property itself and the R1C1-style notation. However, my focus on this particular VBA tutorial isn't comparing the Range.FormulaR1C1 property with the Range.Value property. In practice, using FormulaR1C1 “produces the same result”. Notice how the macro recorder uses the FormulaR1C1 property every single time.Īs explained in Excel 2016 Power Programming with VBA and by Bob Phillips at, you normally use the Range.Value property for purposes of entering a value in a cell. I recorded my actions while (i) entering numbers 1 through 5 in cells B5 to B9 and (ii) selecting cell B10 at the end. To give you an idea, I used the macro recorder for purposes of creating the following sample macro (Enter_Value_FormulaR1C1). This is because, as explained at Stack Overflow, the macro recorder constantly uses FormulaR1C1.įor example, even though you normally use the Range.Value property for purposes of entering a value in a cell, the macro recorder uses the Range.FormulaR1C1 property for those same purposes. If you've used the macro recorder, you're probably familiar with both R1C1-style notation and the FormulaR1C1 property.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |