Macro that goes through each row to find specific values and then creates a message box

Hi Everyone,

I have a macro that goes through each row in a sheet and if a cell in Column D has "CIBC" and Column F has "FRN", a message box is supposed to appear. Everything is working except it stops the macro once the first CIBC FRN is found. I need it to continue through the whole sheet to find all the CIBC FRN. I have played around with it and nothing seems to be working, can you help?

Please Login or Register  to view this content.

This Macro would look through all the rows like I need but the message box does not have a Yes/No option. I want the workbook to close without saving if you click no and continue with the macro if you click yes. I have changed the macro to include the Yes/No option but now it is giving me a run time error. Looks like the loop isn't ending as it should (once the row is blank). Any ideas?

Please Login or Register  to view this content.

It was missing an "End IF" but now I am getting an error "Overflow". Can anyone help with this?

Please Login or Register  to view this content.