This is another great Excel VBA video that shows you how to add a formula to a single cell or a range of cells using VBA. The video is very clear and runs at a good pace (not too fast and not boringly as a result of being explained slowly).
We also love the way that it shows you to add the formula in the cell first and then copy it into the VBA editor to make sure it is going to work – good tip guys!
The video ends by showing you how you can enter the same formula in many cells simply by changing the range that the .formula=”” applies to and talks about the difference between adding an equation with or without $ signs in them (very important to ensure you understand this part fully).
If you have enjoyed this video or found it useful please let others know by adding comments in the box below or liking or sharing the video using the buttons above