Print Macro Help - Is it possible to Macro so only the pages in a sheet that have data in certain cells are printed?

[Barryoffshore]

I have a workbook that has 87 sheets, and each sheet has 21 printable pages. Is there a macro which will print only the pages that have entries on them? For instance, if on a single sheet, there is data in cells E7, E37, E66 & E95, only the pages that have those cells in them will print. Is a macro like this possible and if so, can someone help me with it please???

Thank you!!!
Bear

 

[Barryoffshore]

Thank you CharlesH... I must say - YOU, SHG, Michael M, Mikerickson and all the truly expert people on this board absolutely amaze me!!!

 

[shg]

shg didn't contribute much to this thread -- I think Michael is today's star.