Printing visible pages

[Anarchus]

Hi there,

This is similar to another question I had previously, but different.

I have one worksheet which is my "Print" sheet. In total, there are 36 pages lets say (I haven't completed the file yet, so not sure of the exact number).

Some of the pages will be conditionally formatted to turn white based on another cell's value (the other cell is a date, sometimes it will appear blank as there is no date).

Is there a macro to insert a commandbutton to print the worksheet but only the pages that are conditionally formatted white so they appear blank?

Basically, I could have pages 1 to 5 appearing, page 6 turns white, page 7 to 20 appear, page 21 to 23 turns white and page 24 to 36 appear. So I would only want pages 1 to 5, 7 to 20 and 24 to 36 to print.

I'm assuming this would be virtually impossible but I have hope! I'm not very good with macro's so I wouldn't know how to write it out exactly.

[Anarchus]

Sorry, that fourth paragraph doesn't make sense.

I will already have a commandbutton on the page of course. I want the macro to print the pages that don't appear conditionally formatted white, these white "blank" pages I don't want to print at all.