Advanced Excel- Day 3 - How to format with VBA

What this lesson covers:

  • Formatting with VBA is crucial to automating reports where you need to make sure they look right otherwise you can waste time 'fixing' them
  • We will be diving in to:
  • Controlling Fonts
  • Colouring Cells
  • Clearing Cells
  • Setting Column Widths