IF statement does not stop correctly

[heathb]

Hi all

I was recently given the below code which seemed to work correctly, but unfortunately it does not stop when it comes to the field "lost clients". It carries on rather than stepping to the next piece of code. I have tried multiple times to fix this myself, but as usual failed. All help appreciated.
Thank you

Please Login or Register  to view this content.

[AB33]

The code has 3 ifs statements. If the row is not "LOST CLIENTS" , it will go on and test the same row for not empty and so on.
It may be you have upper case of "LOST CLIENTS" where the code will not find it if it is in lower case.

[AB33]

Please Login or Register  to view this content.

[heathb]

Hi, "LOST Clients" is in upper case in both

cannot attached a file, as the system tells me it is to big??

[JasperD]

You say "unfortunately it does not stop when it comes to the field "lost clients", but nowhere in your code it tells to stop when that code is found - it only says that the value in column C shouldn't be changed, but not to stop the code...
Try this :

Please Login or Register  to view this content.

I use the InStr method in case you have "invisible rubbish" or spaces in front or at the end of your cell...

Please click the * below if this helps

[heathb]

Makes sense, now get Compile error on the first Else - saying "Else without If"

Scrap that - works now

[millz]

Move the "Exit For" to the next line

Also make sure the first "End If" is commented out, like in the example posted above