MM0024 - 11/05/20 - Automating Work Scheduling With Excel 2

Scheduling shifts is a great example of a task that could take some time, but could be automated with Excel VBA - let's give it a try!

Topics

  •  | Iain L - Homework Review
  •  | How To Access Formulae In VBA
  •  | Use Of Underscore In VBA
  •  | Discussion: VBA vs. Formulae
  •  | Role Of Constructive Challenge
  •  | Problem With Events To Trigger VBA
  •  | Macro Recorder Example
  •  | PasteSpecial Method Of Range Class
  •  | Example Of Full VBA Debug
  •  | Test In A Safe Space
1 Lesson