Printing only non-blank rows

M

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
 
J

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
 
J

Jason Morin

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

Jason
 
Top