From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Running a macro

Running a macro

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Running a macro

- We're looking at the worksheet PricingSheet. It's in our file 15 - Macros. It's a strange worksheet in that we cannot figure out what's going on very easily. We've already identified the need to locate the cells that have formulas. That's pretty easy. From the Home tab, far right button, Find & Select, choose Formulas. That's also a feature that we might use in other worksheets as well. In fact, maybe we're the person in the organization that people turn to to help them figure out what a file is all about, what a worksheet's all about. We've become the worksheet guru maybe. That's a handy feature. And it's short enough to say, "I don't mind doing it manually." But on the other hand, we could turn that into a macro. Now there's a companion feature that's going to take a few more steps, but it's pretty valuable too. We might want to highlight just the cells that have pure numbers in them. And we can do that by first clicking on a single cell, going to the Find & Select button again on…

Contents