VBA Code to hide rows if Cells = 0 or blank

[robertk93]

I am working on two different sheets within the same workbook. I have cell headers for certain sections- that when sub items have a value, the header auto fills, thus I need to use a formula similar to this above (I would guess). Any help is much appreciated!

I have one sheet where I input the value and if a certain line item has a number in it (not blank), then it would move over to the other sheet with the line item description, etc. I also have different sections that certain line items fall under.

 

[robertk93]

Did you add those lines of code to ALL of your other procedures, like I suggested?
Exactly how long does the code take to run?
I understand that there is flickering and lagging, but is it actually doing what it is supposed to?

I have no other procedures. As I enter a value, it updates each time and flickers and lags. Yes, it does what it's supposed to, but the flickering is not good. Should I need to enter any other sort of procedure?

 

[Joe4]

You did not answer one of my questions, how long does the code take to run?

 

[robertk93]

You did not answer one of my questions, how long does the code take to run?

As I enter a value, it updates individually with each line- a few seconds.

 

[Joe4]

OK, so the original question/problem has actually been answered/solved then.
And now you want to see if you can do something about screen flickering, which could be due to other features of your workbook.

If might be best to post a new thread on that, and post a copy of your workbook to a file sharing site and provide the link in that, as helpers may need to access your actual workbook to determine exactly what is going on. If you do that, just be sure to replace any sensitive data in your workbook with "dummied up" data.

 

[robertk93]

Done!