From the course: Excel: Macros in Depth (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Recording and testing a macro
From the course: Excel: Macros in Depth (Microsoft 365)
Recording and testing a macro
- [Narrator] After seeing a few Macros, perhaps sensing a potential value to you, let's actually create one. And keep in mind too, when you see a Macro don't always assume that it's going to be valuable to you. Ideally a Macro is based on the concept that you find it valuable. It's going to save you some time. So what I'm suggesting here is the Macro you're about to see might not be valuable to you, I know it has been for me. I frequently want to know which cells have values in them, numbers that are not formulas. So, how do we begin this process? If we were doing this manually, we'd click a single cell, go to the Find and Select button on the Home Tab choose Go To Special, you might not have seen that feature, we'll click Constants and these boxes below, although they look like they're for the Formulas button they also apply to constants. We want to see constant numbers but not text, logicals or errors. Click…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.