Hiding Rows With A Cell Containing "0"

**ExcelBob** · 10-25-2006, 06:49 AM

Hi All

Can someone please give me a bit of code so that when I open a sheet (which takes data from another sheet) it hides rows which contain a zero in a certain cell?

Thanks in advance
ExcelBob

**Mallycat** · 10-25-2006, 07:01 AM

It depends. If all the cells are in the same column, just use an auto filter that filters out zeros. If the zeros can be anyware, you will need a macro. But then again I doubt they can be anyware. Can you give some more detail about where the zeros can appear.

Matt

**Carim** · 10-25-2006, 07:02 AM

Hi,

To be adapted to your needs ...

Please Login or Register  to view this content.

HTH
Cheers
Carim

**ExcelBob** · 10-25-2006, 07:11 AM

Thanks for help. Still can't get it to work so will explain some more.

Basically I have data in cells A15 to F37

Where there is a "0" in cells F15: F37 I want the entire row to hide. I would like this to be automated when the workbook is opened...

Thanks again.... :D

**davesexcel** · 10-25-2006, 07:20 AM

of course there is code for that but there is also autofilter, select the range you want to filter and goto data autofilter..
but here's some code to hide rows, it searches rangeK1:K25 and hides whatever row is equal to zero

Please Login or Register  to view this content.

**Carim** · 10-25-2006, 07:28 AM

Hi,

Insert code in event macro

Please Login or Register  to view this content.

HTH
Carim

**Carim** · 10-25-2006, 07:29 AM

Oops

make sure to change starting point to

Please Login or Register  to view this content.

Carim

**stevekirk** · 10-25-2006, 11:34 AM

hi carim

this code is helpful to me

but when i run it it does not stop
any ideas please?

steve

**Carim** · 10-25-2006, 01:13 PM

Guess,

I am typing too quickly ...
.Value has nothing to do in this code ...

Please Login or Register  to view this content.

HTH
Carim

**stevekirk** · 10-26-2006, 03:55 AM

hi carim

still a problem with code if the last row has 0 in it the last row does not see it

any ideas please

steve

**Bunches** · 04-23-2008, 01:07 PM

Thanks for the help. I've changed the code a little for my specific needs and thought it may be of use for someone else.

Please Login or Register  to view this content.

Thanks again Dave!

Bunches

Hiding Rows With A Cell Containing "0"

LinkBack

Thread Tools

Rate This Thread

Display

Hiding Rows With A Cell Containing "0"

Slightly adaption of Davesexcel code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions