do not print rows with zero data

[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

 

[Earl Kiosterud]

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.

 

[Guest]

thanks for your reply ...

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

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
-----------------------------------------------------------------------

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

 

[Dave Peterson]

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...

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
-----------------------------------------------------------------------

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