I am using Select Case in VBA.
Also, I am working with column B which is TEXT and contains 3 digit numbers formatted as TEXT ie 123, 712, 750, 990
If the value starts with '7', how would I write the code to place the word 'complete' in col J? I tried a wildcard (*) but that didn't put the word in the cell.
Case "7*": Cells(cl.Row, "J") = "COMPLETE"
Thanks in advance,
XLML
Also, I am working with column B which is TEXT and contains 3 digit numbers formatted as TEXT ie 123, 712, 750, 990
If the value starts with '7', how would I write the code to place the word 'complete' in col J? I tried a wildcard (*) but that didn't put the word in the cell.
Case "7*": Cells(cl.Row, "J") = "COMPLETE"
Thanks in advance,
XLML