View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ripper Ripper is offline
external usenet poster
 
Posts: 25
Default 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