Excel VBA – Formulas

Thanks! Share it with your friends!

Close

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

Comments

Attah-Osei says:

I think you have done well for newbies

Write a comment

*

 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.