Macro for Printing Visible Data only

[mamuka12]

Good morning, I've been trying to find a solution for my issue for quite a while online and still no luck.

In the attached file columns C1: P28 have a picture. In addition,I'm using formulas in the C30:P460, and if there's no data it returns "". When I want to print out the results it would print all the cells that have formulas in them even the blank ones ("") and that can be 10 pages (7 of which are blank). Is there any way to have a macro that will use the current range to select and print just the cells that have visible data (including the picture)?

Thank you very much in advance!

[protonLeah]

You should have posted a more realistic workbook....