Printing Visible Data

[Cremorneguy]

Hi there,

Not sure if this is possible but anyway.

My spreadsheet extracts information from another spreadsheet (a basic ="Sheet1"!A1 formula with a few other things so it either appears with data or appears blank).

Sometimes the cells will become blank (on purpose). I've set it up (margin size) so the information from each row will appear and print as one page. Sometimes I will information showing on pages 1,2,4,6,7 etc while pages 3,5,8 will appear blank.

Is there a macro or something that can help so when I go to print (Ctrl+P) it only prints the pages that show visible data (even though every cell has a formula, I only want the pages where data is actually appearing, I don't want the pages that return the value to 0/blank printing). In this example only pages 1,2,4,6,7 will print. In excel there is no option to print selected pages, only a range of pages so I don't want to have to keep changing the ranges, I want to be able to hit print and all the pages with data appearing will print and all the blank pages will skip over.

Thanks

[AlphaFrog]

You could print one page at a time if a specific cell (or a range of cells) on each page pasts the test (not empty).

Example:

Please Login or Register  to view this content.