ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide/Unhide rows for printing (https://www.excelbanter.com/excel-discussion-misc-queries/183847-hide-unhide-rows-printing.html)

Ripper

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


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com