Hide / Unhide columns 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 "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?

--
Thanks As Always
Rip

Hide / Unhide columns for Printing
 

DataFilterAutofilter 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

On Wed, 16 Apr 2008 07:03:03 -0700, Ripper
wrote:

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?