Deleting blank rows and have formulas but have no value

[josros60]

How can delete blank rows from a range that contains formulas but have no value using VBA, any sample please.

Thank you

 

[Peter_SSs]

The code in post #10 does that for me. I copied your sheet from post #14 to my sheet then copied that column H formula down column H to row 80.
I then ran the code and then the only rows with anything left in them were rows 15 to 20.

If that is not happening for you then it would seem that there is something different between your actual data/workbook and what you gave us in post #14. If there is something different then you are going to need to give us some of that different data or at least tell us what the difference is.

A couple of other things to consider that have been raised before but not addressed.

@josros60
Are you sure that you tried the post #10 code?
If you have and it did not do what you want, can you post another mini-sheet that includes some extra rows like you are describing in words but so far not including in your mini-sheet?

Now I'm a little confused as to whether your data is in a formal Excel table (ListObject) or just a normal range that you are referring to as a "table".