printing filtered data

  • Thread starter Thread starter kildevil
  • Start date Start date
K

kildevil

My worksheet's size varies from 12 to 100 rows. To identify rows with
data, I have a hidden column "A" which displays a character if the row
has any data entered. I have entered a "fixed" character in cell A100.
To print, I used a macro to unhide column "A", activate Autofilter,
show rows with a character in the hidden column (row 100 always appears
due to the "fixed character), and print the displayed rows.
My problem is that rows without a character in column "A" are being
printed. Usually, my worksheet should print on 1 page. I cannot get
only rows with a character in column "A" to print. I am getting many
blank rows.

Is there a flw in my reasoning?
 
hi

you may need to clear the print area
file / print area / clear print area

and you shouldn't need to set it again .. .it should work pretty much
automatically

let us know how you go

Cheers
JulieD
 
It's hard to tell what the problem is, without knowing what character
you use, how it's put in the cell (manually or formula result), or how
you filter the column.

You could use the following formula in cell A2:

=COUNTA(B2:H2)>0

Copy down to the last row of data, then filter for TRUE, to hide the
rows that contain no data in columns B:H.
 
Back
Top