Deleting row with condition

[kaffal]

I have a workbook with hundred of worksheets.

I would like to have a macro that will loop through every sheet, except for the first sheet,"Summary". It will delete rows if it is empty row and the entire row does not contain "Captured" in the whole row.

When the row is deleted it will shift the row up.

[Greg M]

Hi there,

There's some clarification needed here:

It will delete rows if it is empty row and the entire row does not contain "Captured" in the whole row.

An empty row cannot have any cell which contains the value "Captured".

Do you want to delete all empty rows and all non-empty rows which do not have a cell containing the value "Captured"?

Regards,

Greg M

[kaffal]

sorry typo error , should be: It will delete rows if it is empty row or the entire row does not contain "Captured" in the row.

I forget to mention that the search will only start on the row 2 of every worksheet except Summary

After deleted, it will shift the row up

[VBA Noob]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!