How can I hide the rows based on the cell reference..

[krishnakuma6]

Hello guys,

Pls help on the below request....

I need the code for hiding the rows based on the cell reference..

Pls find the sample sheet.

In that sheet1 C1 = 500, In B column, each cell value is >500 to be hide.
If I Change C1 to 1000, then in B column, cell value is >1000 to be hide

[HaHoBe]

Hi, krishnakuma6,

right click on tab for Sheet1, View Code, Code goes behind Sheet1 and will be fired if Cell C1 in Sheet1 is changed manually:

Please Login or Register  to view this content.

Ciao,
Holger

[krishnakuma6]

Thx HahoBe,It's workimg fine,I need one more favour from you, Plss change the status as solved, I don't know how to change.

Once again Thx a lot

[HaHoBe]

Hi, krishnakuma6,

only the thread opener and moderators/administrators can do according to the settings, so please have a look at [url=http://www.excelforum.com/faq.php[FAQ[/url]:

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

HTH
Holger