hiding cells via macro
 

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

hiding cells via macro
 

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

hiding cells via macro
 

why not just use datafilterautofilter and then print
to hide use the same idea if a common item or record a macro hiding the rows
--
Don Guillett
SalesAid Software

"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

hiding cells via macro
 

Hi Matthias

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

There is a example for both questions



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


"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