Collapsing a table

[Guest]

I have an Excel table, defined as "database" that contains 100 rows, followed
by a totals line. My problem is this:
Sometimes I will need to use all 90 rows in the table, but quite often,
there will be a need for considerably fewer rows, and I wind up wasting paper
printing all the blank rows in the table that contain no data. Is there a
was to collapse the table so that it does NOT show all the blank record lines?

 

[Guest]

I would set up a macro or script that would check each line in the table and
hide the row if it is blank. Do your printing, then unhide the hidden rows
later.

 

[Debra Dalgleish]

Record the steps as you select a cell in the table, and choose
Data>Filter>AutoFilter.
Then, filter one of the columns for Non-blanks.
Print the sheet
Choose Data>Filter>AutoFilter, to remove the filter

 

[Guest]

That's a great idea, but it's the code I am struggling with. The number of
blank rows is going to be different each time, and I am probably making this
harder than it needs to be. The only macro's I have ever done are of the
point & click variety.