Printing only non-blank rows

[Matthew McManus]

Hi all,

1) Is there a command I can use or a macro code so that I only print
non-blank rows?

2) Similar problem: is there a command or macro so that I only print
rows that do not contain error values?

Thanks for any ideas

Matthew

 

[Jason Morin]

An alternative to VBA is to apply an Advanced Filter and
filter for those rows that only contain data. Try this:

1. An empty cell below your data (say E100), put:
=COUNTA(2:2)>0
where row 2 is the 1st row of data and row 1 = headers.
2. Select your data and go to Data > Filter > Advanced
Filter.
3. Select E99:E100 for your criteria range, ensuring E99
is empty.

HTH
Jason
Atlanta, GA

 

[Jason Morin]

I forgot to mention that after the filter, you are now
ready to print the visible rows.

Jason