Astute Excel: Intro to Macros Part 3
Presented by David H. Ringstrom, CPA
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.