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
2 Critical VBA Assumptions: https://youtu.be/VohlY8WqLCg
Free webinar on learning macros & VBA: https://youtu.be/EN8fSXjGFnI