Join Dennis Taylor for an in-depth discussion in this video Creating macros with the recording process, part of Excel for Mac 2016: Macros.
- [Narrator] Even experienced macro creators tend…to use what we call the recording process.…It's the dominant way to create a macro.…Who likes to type in code when…you can use the recording process?…Let's imagine in this worksheet here, cold formulas.…We want to highlight all the cells…that have just pure numbers, not formulas, but numbers.…Now you will recall, there's a very quick way…to highlight just the formula cells.…You can go to the edit tab in the menu.…Choose find.…Go to.…Special.…
Formulas.…While we're here, by the way,…notice you could also choose constants.…But, click okay.…We've highlighted just the cells with formulas.…How about the other cells that have numbers in them?…For example the ones in B3 and B4 out here.…How do we highlight those?…Same general technique.…Now, let's imagine we've done this often.…In a lot of different worksheets.…And we've recognized the name we've been doing it enough,…we'd like to be able to do it faster.…And we haven't really counted the steps,…but it's eight, or 10 or 12 steps, we're not sure.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with existing macros
- Creating macros with the recording process
- Viewing and modifying VBA code
- Running a macro from the Developer or View tabs
- Running a macro from a keystroke shortcut
- Running a macro from an object or picture
- Creating and updating the Personal macro workbook
- Recording a formatting macro
- Expanding a macro with an IF statement
- Creating interactive macros
- Stepping through macros