ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I exclude empty cells from being printed? (https://www.excelbanter.com/excel-discussion-misc-queries/40276-how-do-i-exclude-empty-cells-being-printed.html)

pox

How do I exclude empty cells from being printed?
 
I am doing a loan calculator programme and want to exclude empty years from
printing [eg. if the loan is for 5 years, I don't want to always print the
whole 45 years]. Is there a way to hide specified cells before printing?

Ron de Bruin

Hi Pox

See
http://www.rondebruin.nl/print.htm#Hide

--
Regards Ron de Bruin
http://www.rondebruin.nl


"pox" wrote in message ...
I am doing a loan calculator programme and want to exclude empty years from
printing [eg. if the loan is for 5 years, I don't want to always print the
whole 45 years]. Is there a way to hide specified cells before printing?





All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com