Posts by Stelli1989

Thank you very much for your help.

It works great. I just changed the first Line where you selected the Worksheet to this:

For Each ws In ThisWorkbook.Sheets
ws.Select

So all Worksheets will be searched, one after another.

Thank you

Hi,

i've got an excel file which contains more than 50 worksheets. All of them have the same first labeling line.

I am trying to get a vba to work which searches each worksheet for following criteria:

When a Cell in Column A is not empty then check if Cell in same row on Column K and L is empty. If one of them is not empty do nothing.

If both of them are empty check if Column M is empty.

If Column M is empty, check if Date in Column D is max. 3 days in the future Then jump to this row.

Else check next row until all Worksheets are done.

If there are no cells which meets the criteria a MsgBox should appear to confirm that no unfinished rows exist.

I would thank you For any suggestions.