Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
do not print rows with zero data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
do not print rows with zero data
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
do not print rows with zero data
thanks for your reply ...
i was looking for a macro that would do it for me... "Earl Kiosterud" wrote: 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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
do not print rows with zero data
Record a macro when you do it manually and you'll have the code.
manfareed wrote: thanks for your reply ... i was looking for a macro that would do it for me... "Earl Kiosterud" wrote: 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
select rows to print where there's data in specific column | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Printing only Rows with Visible Data | Excel Discussion (Misc queries) |