| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT | Excel Worksheet Functions | |||
| Printing a certain amount of pages based on amount of data | Excel Programming | |||
| How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
| How to have an error popup once range cell amount is greater than | Excel Discussion (Misc queries) | |||
| Printing Multiple Pages Based on Different Cell Criteria | Excel Programming | |||
Threaded Mode
