I would like to look at each cell in column C, and determine if there are 5 char between the first . and the second .
I can do the for each cell in range part, but i cant make the . to . length work. For arguements sake lets assume that i want to display the value in column C in a message box if the there are 5 char between the first dot and the second dot in the string.
Eg
ABC.APR13.34235.O (This one shows up in message box)
ABCD.D(C).23123.T (This one doesnt show up as its 4 char between dots)
I can do the for each cell in range part, but i cant make the . to . length work. For arguements sake lets assume that i want to display the value in column C in a message box if the there are 5 char between the first dot and the second dot in the string.
Eg
ABC.APR13.34235.O (This one shows up in message box)
ABCD.D(C).23123.T (This one doesnt show up as its 4 char between dots)