print only color filled rows

C

chief

what code in a command button could make it so that only rows that ar
not color filled will be printed?

thank
 
D

Dave Peterson

I'd use a UserDefinedFunction to return the value of the color in a help column
of cells.

Chip Pearson has a couple of functions at:
http://www.cpearson.com/excel/colors.htm

Then I'd just apply Data|Filter|autofilter to show only the rows I wanted to
print.
(custom, equal to, ...)

Then print, and data|filter|showall.

And if that helper column is too ugly, hide it before you print.
 
Top