Hey guys, so I'm looking to add a little clause at the end of some of my macros.

First, all the macros due is apply some filters to a slicer. For example:

"Shipment late" = True
"Shipment verified" = False....

Etc. Etc.

What I'd like to do, is add a lump of code at the end that provides a message if the filters don't exist. For example, if I wanted to click the button that showed me which parts are running late, but NO Parts are running late, it would just say "No late parts found."


The way my macros work is that I have a column which decides, using IF formulas, if a part is late. So - Is it possible to write some VBA that either A: Checks the slicer for the late option or B: Checks the column where the formula is (Let's just call it 'A' for now)

Thanks in advance!