Code deletes HEADER Row

[rz6657]

A code is designed to delete rows by a certain phrase. It works great so as long rows under the header row has data. If the row(s) under the header row does not have any data (some scenarios call for no data), it will execute the routine and ALSO delete the header row. How can the code be adjusted for this scenario?

See attached file sample:

Data Dump = with data. If you run code, it works fine.

Data Dump 2 = no data. If you run code, header is deleted as well. I need rows C5 and before to not be deleted...


Thanks.

[Norie]

If there's no data then .Cells(Rows.Count, "H").End(xlUp).Row will return 5, the header row.

Add a check to make sure the delete part of the code doesn't run if that is the case.

[rz6657]

Norie -

Can you recommend a check in case of no data? I'm stuck there...Thanks.

[tehneXus]

try this:

Please Login or Register  to view this content.