Hide / Unhide columns for Printing

  • Thread starter Thread starter Ripper
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Hide and Unhide Rows 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Excel 2007 - Hide & Unhide Columns/Rows 8
How do I suppress printing a row without hiding it? 5
Command button unhides but not hides 1
Hide row code help 1
hide, unhide column or row after protect worksheet 4
Help with conditionally unhiding columns 1

Back
Top