Deleting rows where equation results are ""

[Glervey]

Im stuck on this code

Please Login or Register  to view this content.

I think because there are equations in the blank cells that this isnt working.

I also would like to make this code go through and do this on two specific tabs, "Header_Credits", and "Header_Bills".

[JLGWhiz]

Test this on a copy first.

Please Login or Register  to view this content.

Just a note of observation: Using a reserved word like EntireRow as a variable is not a good practice and can result in undesired results because the compiler may treat the word differently than you expect.
It is better to use fragments of words or abbreviations as your variables, but not the same as the constants reserved by VBA for executing specific functions in Excel or other MS applications.

[Glervey]

This works great! How would I make it loop through each row through the 2 tabs referenced in my original post?

[JLGWhiz]

This works great! How would I make it loop through each row through the 2 tabs referenced in my original post?

We know which sheets you want to apply it to, but it is extremely difficult to figure out what you have selected.

Please Login or Register  to view this content.

[Glervey]

This only does one line at a time and if it falls on a cell with values it gets stuck

[JLGWhiz]

This only does one line at a time and if it falls on a cell with values it gets stuck

let me try to be clearer. We cannot help you with what you want to do because we do not know what range on the sheets you have selected. If you can provide us with the range of rows to check for each sheet, then somebody can respond with code that would do what you wnat.

[JLGWhiz]

This code will look at the entire sheet of data. If you do not want the entire sheet evaluated, don't try this code.

Please Login or Register  to view this content.