Printing x amount of pages if cell is greater than 0
 

Hello,
I have a spreedsheet, with around 50 tabs, on some of the tabs I have the
same print sheet set going down to around 100 pages. The only thing that
changes on the sheet is one cell as you go down each print page (eg A4=1,
A20=2, A30=3 (The number change depending on another sheet tab) What i need
is a way that i place a VBe in so it will only print all the sheets on the
tab down to where the cell =0. (0 is changed by a simple "If" format)
If anyone can help.
Many Thanks
James