hiding cells via macro

[matthias]

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

 

[Paul B]

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

 

[Don Guillett]

why not just use data>filter>autofilter and then print
to hide use the same idea if a common item or record a macro hiding the rows

 

[Ron de Bruin]

Hi Matthias

Start here
http://www.rondebruin.nl/print.htm

There is a example for both questions