do not print rows with zero data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a an Exxel 2003 spreadsheet populated from columns A to AN and up to
row 976.
The problem is that a lot of these rows have zero values which I do not want
to print. Also it isn't always the same rows with zero values.

I need a macro which detects rows with zero values and only prints out rows
which have data in them. [maybe use a 'print' button in the face of the
spreadsheet to do this.

Please let me know if you have any ideas.

Thanks
manfareed
 
manafareed,

You may be able to hide the rows with zeroes with Autofilter before you
print. A "Print" button for this would require a macro to do the row
hiding, then the printing, then unhiding.
 
thanks for your reply ...

i was looking for a macro that would do it for me...

Earl Kiosterud said:
manafareed,

You may be able to hide the rows with zeroes with Autofilter before you
print. A "Print" button for this would require a macro to do the row
hiding, then the printing, then unhiding.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
manfareed said:
I have a an Exxel 2003 spreadsheet populated from columns A to AN and up to
row 976.
The problem is that a lot of these rows have zero values which I do not
want
to print. Also it isn't always the same rows with zero values.

I need a macro which detects rows with zero values and only prints out
rows
which have data in them. [maybe use a 'print' button in the face of the
spreadsheet to do this.

Please let me know if you have any ideas.

Thanks
manfareed
Click to expand...
Click to expand...
 
Record a macro when you do it manually and you'll have the code.
thanks for your reply ...

i was looking for a macro that would do it for me...

Earl Kiosterud said:
manafareed,

You may be able to hide the rows with zeroes with Autofilter before you
print. A "Print" button for this would require a macro to do the row
hiding, then the printing, then unhiding.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
manfareed said:
I have a an Exxel 2003 spreadsheet populated from columns A to AN and up to
row 976.
The problem is that a lot of these rows have zero values which I do not
want
to print. Also it isn't always the same rows with zero values.

I need a macro which detects rows with zero values and only prints out
rows
which have data in them. [maybe use a 'print' button in the face of the
spreadsheet to do this.

Please let me know if you have any ideas.

Thanks
manfareed
Click to expand...
Click to expand...
Click to expand...
 
Back
Top