M
msnyc07
Apologies gain, still trying to hack this coders VBA as a non-coder so I can
fix as he is AWOL.
Anyway part of the code was supposed to see if a cell contained specific
text but as I test it it only works on a complete match. This is the line of
code:
ElseIf InStr(UCase(CStr(wsCert.Cells(targetCertRowNumber, 1).Value)),
UCase("TEXT")) And Len(CStr(wsCert.Cells(targetCertRowNumber, 2).Value)) = 0
Then
Do I need to change something so it is finding "TEXT Anything" as right now
it is just finding "TEST"
Thanks in advance
fix as he is AWOL.
Anyway part of the code was supposed to see if a cell contained specific
text but as I test it it only works on a complete match. This is the line of
code:
ElseIf InStr(UCase(CStr(wsCert.Cells(targetCertRowNumber, 1).Value)),
UCase("TEXT")) And Len(CStr(wsCert.Cells(targetCertRowNumber, 2).Value)) = 0
Then
Do I need to change something so it is finding "TEXT Anything" as right now
it is just finding "TEST"
Thanks in advance