Intro to Macros Part 3


- +



If you’d like to expand your ability to write programming code, Part 3 of Excel macros is the ideal presentation for you. Excel expert David Ringstrom shows you how to create a macro that can reset workbooks that have skewed scrollbars, as well as a second macro that can be used to instantly unhide all worksheets in a workbook at once. David goes deeper into making decisions in programming code by comparing If and Select Case statements. He also contrasts three ways of creating loops in Excel: For Each, Do While, and Do Until. In addition, David explains how to troubleshoot problematic loops in Excel, which in certain instances can cause Excel to crash.

Topics Covered:

  • Providing feedback to a user by way of the MsgBox method within a macro.
  • Using a two-word macro to fix an annoying problem in Excel where the used range of Excel expands beyond your actual work area.
  • Consolidating data from multiple workbooks into a single worksheet by way of an Excel macro.
  • Returning the underlying number for a color assigned to a worksheet cell for use elsewhere.
  • Understanding For Each Loops within Excel Workbooks.
  • Making decisions in Excel by way of If statements.
  • Contrasting Do While Loops and Do Until Loops.
  • Inserting blank module sheets into Excel workbooks.
  • Learning how to use a single line of programming code to unhide all worksheets within a workbook.
  • Exploring three ways to cause a macro that’s running in Excel to halt.

Learning Objectives:

  • State the keyboard shortcut that takes you to the last-used cell within your workbook.
  • Recall how to create a macro that will unhide all worksheets in a workbook simultaneously.
  • Define how to insert blank module sheets into an Excel workbook.
  • Define how to insert blank module sheets into an Excel workbook.