Hide Row when Cell in column A =0

Here is an example of some code you will need to adapt to your situation.

http://stackoverflow.com/questions/1...d-by-a-formula

Hi juriemagic,

Though this is more cluncky in that it will run on every change in the active sheet, as there's only 46 rows this event macro should suffice:

Please Login or Register  to view this content.

Note this macro needs to inserted on the sheet in question as per the last screen shot of the link Alan provided.

HTH

Robert

You can try this where there's a combination (Change and Calculate) of worksheet events:

Please Login or Register  to view this content.

No other suggestions after this I'm afraid. Did the link that Alan provide help?

Robert

but the cell values are actually dependant on other cell values

That's why I incorporated two worksheet functions - refer my note in the WorkSheet_Calculate event macro.

The code worked for me Do you have the calculation method set to manual?

It just irritates me a bit that Excel takes so long to go through the calculation process.

I just think that's the trade off I'm afraid. At least there's only 46 rows as it wouldn't take long for it to really get bogged down.

If you could mark the thread as solved it would be appreciated.

Cheers,

Robert

Change the above Worksheet_Calculate event macro to this as it may help slightly:

Please Login or Register  to view this content.

Regards,

Robert

You've been helpful and very kind, thank you..It does seem to work a teeny bit faster, thanx.

You're welcome and thanks for marking the thread as solved

Just a question..is it right to have pasted OPTION EXPLICIT with the rest of the code all together?

Option Explicit is only shown once at the very top of each module. It forces you to declare all variables before they are used as opposed to Excel assigning them, which in that case will always be as a variant - the most expensive type of variable in programming terms. This can adversely impact code.

Glad we got there in the end (sort of anyway).

Robert

In fact you don't need the formula reference to sheet2 and you can control it in sheet2 sheet change event itself.

Refer the below code...

Please Login or Register  to view this content.

Refer the attached file

Replace the previous code with the below one...

Please Login or Register  to view this content.

In Sheet1 A10 Cell the group2 mentioned without space. So keep the constant Group heading in both of the sheets.

Sorry you are not at all understanding my point. I can't go further....

unfortunately, as you already said in your first post:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

As you have replies in both of your threads i'll merge them just for this time respecting the effords and the time of the members that replied to you.

If you are changing a dropdown on Sheet2, then switching to Sheet1 to see the results, then you could use the Worksheet_Activate event of Sheet1:

In the Sheet1 module:

Please Login or Register  to view this content.

Originally Posted by juriemagic

Sheet 2 contains a dropdown, and depending on selection, sheet 1 updates.

Requirement gathering by installments is a massive pain. You seem to keep changing the requirements with each potential solution. YOU know the constraints of your workbook, and what you are trying to achieve. WE only have the stuff you post to work with.

Attach a workbook which accurately reflects your actual requirement, instead of wasting a lot of time revealing only snippets or inaccurate examples of how your workbook is put together.

What we're clear about is a method which works to hide the necessary rows. What we're trying to understand is how to trigger that change.

In your latest example, the trigger is changing the dropdown value in Sheet2!A1. So let's capture that worksheet_change event for that range, and hide / unhide the rows on Sheet1 when that happens - so put this in the Sheet2 module (replacing the code that is already there):

Please Login or Register  to view this content.

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

CrossPosted: http://www.mrexcel.com/forum/excel-q...ml#post3980268

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No feedback to my post #26, then?

So to smooth the visual effect, add a couple of lines to the code to disable screenupdating while it runs:

Please Login or Register  to view this content.

juriemagic: Just to put the record straight, the forums are not related. It is just that many people post to multiple forums and this type of situation does not go unnoticed. We have no issue with crossposting, but if you do, then please let people in both forums know. It is just a matter of courtesy and as you have just found out feedback is very important. Good luck with your excel adventures and we do look forward to seeing you here at Excel Forum.

Did you TRY the amendment in post #31?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by juriemagic

Proverbs 3:5..Do not rely on your own understanding..

I did it again. Your code is PERFECT, everything is exactly like I wanted it...Thank you Olly!!

Glad we got there in the end. Happy to help.

There's a lot of help available on this forum, but you have to take the time to work out how best to work with people. A few pointers we can learn from this thread:

We only know what you explicitly post - detail is everything. Don't assume other people will "get" something: explain it in detail.
When you post an attachment to demonstrate your problem, make sure it matches both your description, and your eventual application.
When someone suggests something, TRY it; don't assume you know better.
Don't disappear if you don't get an answer you like in the first 5 minutes. Most of us are prepared to keep working with you to reach an eventual solution. We need you to work with us.