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.
Last edited by jeffreybrown; 08-22-2013 at 07:45 AM. Reason: added code tags
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.
Please Login or Register to view this content.
Hi, "LOST Clients" is in upper case in both
cannot attached a file, as the system tells me it is to big??
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 :
I use the InStr method in case you have "invisible rubbish" or spaces in front or at the end of your cell...Please Login or Register to view this content.
Please click the * below if this helps
Please click the * below if this helps
Makes sense, now get Compile error on the first Else - saying "Else without If"
Scrap that - works now
Last edited by heathb; 08-22-2013 at 11:11 AM. Reason: comment not required
Move the "Exit For" to the next line
Also make sure the first "End If" is commented out, like in the example posted above
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks