Hide / Unhide columns for Printing

R

Ripper

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 "Not Started".

I am saving a value in E that will delineate whether a job is started / in
progress / or complete. One of the reports to print is any job that is not
started
yet. Therefore I want only the rows with "Not Started" in E to print. Then,
I want
the rows unhidden when printing is complete.

There are 125 rows with data.
A: Job
B: Assigned Personnel
C: Department
D: Contact
E: Status

How could I achieve this?
 
G

Gord Dibben

Data>Filter>Autofilter will get you the rows with "Not Started" although you
have conflicting statements regarding what you want printed so your choice.

Print your results then remove the autofilter.

All this can be recorded by the macro recorder.


Gord Dibben MS Excel MVP
 
Top