MM0022 - 27/04/20 - Speed Up A Typical Excel Task With Excel VBA

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

  •  | Conceptualise A VBA Task
  •  | Create A Report Template Using VBA
  •  | Integer Variable Example
  •  | With … End With Example
  •  | For / Next Loop Example
  •  | Control A Loop With A Variable
  •  | Always List Assumptions
  •  | Range(Range,Range) Example
  •  | Breakpoint Example
  •  | COUNTA
  •  | Convey Extent of Ranges
  •  | Use The Macro Recorder
  •  | Code To Transpose Data
  •  | Combine Offset With Variable
  •  | Breakpoint Example
  •  | The Likely Source Of An Error
1 Lesson