p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB How-To (http://p2p.wrox.com/forumdisplay.php?f=78)
-   -   How do I hide Excel rows with zero values-no print (http://p2p.wrox.com/showthread.php?t=57069)

LMG April 24th, 2007 04:37 PM

How do I hide Excel rows with zero values-no print
 
My excel spreadsheet needs to hide rows that have no values, so space is saved on the printout. Cells in each row currently contain formulas referencing info from other tabs.

I would like A16:J81 to start out hidden and show up as needed when info is typed into the other tabs. If no info, then row should remain hidden.



Thanks!
LMG


All times are GMT -4. The time now is 06:41 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.