If/Then statement with Autofilter

  • Thread starter Thread starter Rev Dev
  • Start date Start date
R

Rev Dev

Is there a way to write an "IF/THEN" statement which
would do the following: Assume row 1 (columns A through
G) contains column headers. Assume Column H would be the
Helper column to use with the Autofilter. Assume rows A:2
through G:10 is where data goes. Assume that cell A4 and
cell A7 do not have data in them. I would like to print
showing only rows A2, A3 and A5, A6, A8, A9, A10 (since
A4 and A7 do not have data in them, I would like to
suppress that entire row from being printed).
 
Rev

You could write your If/Then statement in VBA code to hide the rows before you
print.

You could Autofilter on Column A to not show blanks.

Maybe easier would be to hold CRTL key and select rows 4 and 7 then
right-click and "Hide".

Do your printing then unhide.

Gord Dibben Excel MVP
 
Back
Top