hi all
when im printing a sheet the print area is automaticly set to all cells
containing formulas ,even if the formula resualt is nothing.
how can i set the print area to change automaticly and print only
cells where the formula resualt in NOT nothing ?
(i get the data to the sheet from a database, and the size of the
report is changing every time. next to the data im getting from the
data base i have the additional formulas )

thanks
Oz.


--
oz_saar
------------------------------------------------------------------------
oz_saar's Profile: http://www.excelforum.com/member.php...o&userid=23131
View this thread: http://www.excelforum.com/showthread...hreadid=392156