Your message indicated that the field contained 'yes', whereas it contains 'Yes'. The function is case sensitive. If you want it not to be then you need to change the line to
If LCase(xlSheet.Range("G" & iRow)) = "yes" Then
Your message indicated that the field contained 'yes', whereas it contains 'Yes'. The function is case sensitive. If you want it not to be then you need to change the line to
If LCase(xlSheet.Range("G" & iRow)) = "yes" Then
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com
Posting Permissions
Reply With Quote