Printing only non-blank rows

  • Thread starter Thread starter Matthew McManus
  • Start date Start date
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
 
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
 
I forgot to mention that after the filter, you are now
ready to print the visible rows.

Jason
 
Back
Top