| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide/Unhide rows for printing
I would like to create a script that would execute previous to printing that
would hide any row that the value in the Cell E is blank. I there is ANYTHING typed in E I want it not to print. I am saving a value in E that will delineate whether a job is started / in progress / or complete. One of the reports I have to print is any job that is not started yet. Therefore I want only the rows with blanks in E to print. Then, I want the rows unhidden when printing is complete. How could I achieve this? -- Thanks As Always Rip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB Code to hide and unhide rows | Excel Discussion (Misc queries) | |||
| hide or unhide rows with button | Excel Discussion (Misc queries) | |||
| Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
| How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
| Hide Unhide Rows | Excel Discussion (Misc queries) | |||
Linear Mode
