3 Tips for Writing Formulas with VBA Macros in Excel

3 Tips for Writing Formulas with VBA Macros in Excel

In this video I share 3 tips for writing and creating Excel formulas with VBA macros.
Download the file: https://www.excelcampus.com/vba/writing-formulas-with-macros/
You will learn:
1. How to use the Formula property of a range object to insert a formula into a cell. The formula is text that begins with the equals = sign and is wrapped in quotation marks.
2. How to use the macro recorder to create the VBA code for more complex formulas that contain special characters.
3. What R1C1 style formula notation is and how it works. R1C1 allows us to create relative references to cells (rows & columns), instead of hard coding cell addresses like A1. R1C1 can be used for both absolute and relative references, and also mixed references (absolute row & relative column).

Register for my free upcoming webinar on getting started with macros & VBA: https://www.excelcampus.com/yt-vba-webinar

Related videos:
2 Critical VBA Assumptions: https://youtu.be/VohlY8WqLCg
Free webinar on learning macros & VBA: https://youtu.be/EN8fSXjGFnI

Leave a Reply

Close Menu