matthias, have a look here for ways to do it, if you need help post back

http://www.rondebruin.nl/print.htm#Hide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"matthias" wrote in message
oups.com...
Hello everybody,

i have the following 2 problems:

first
i want to print a spreadsheet, but i want to create a function that
hides all the rows were the cells in the first column are equal to
zero. anybodu an idea, via a macro maybe?


second

i want to have a function that hides a certain range (for instance from
a2-a10). anybody an idea?

thankx

matthias