Deleting Blanks

[Ilona29]

Hi everybody, I have another question
How can I delete/hide rows which contain formulas but doesn't contain any text, like they areblankswith formulas. But if something changes in the cells where the formula refers to and blankschanges with text the raws appear automaticly.
Sorry for my English and thanks in advance

 

[James006]

Hi,

If you want to hide / display rows, i.e toggle between the two, based on some input, you will have to use an Event macro such as Worksheet_Change()

HTH

 

[Andrew Poulsom]

Have you tried AutoFilter?

 

[Ilona29]

Have you tried AutoFilter?

yes I tried, but if i change something in the cell to which the formula refers, it doesn't appear

 

[Andrew Poulsom]

You need to refresh the AutoFilter.

 

[Ilona29]

ok, how can i do it?

 

[Andrew Poulsom]

Just click the dropdown, then OK.

 

[Ilona29]

thank you so much)