Quote:
Originally Posted by adj
I've tried a couple of different major approaches (one approach is Find; 2nd approach is to have the macro look at each word). I'm going to try to figure out which approach is best (or whether a combo is necessary) ........ the Right function is any UPPERCASE letter--i.e., what to use between the quotes (after the '=' sign) in the Right function.
|
I don't see how processing by word is going to help. It still has the same basic issue that there are two disparate data sequence type BC-3, ABC-5, BC-003 and DA-378-A, which will require separate processes.
Also processing sequentially in this manner is very slow compared with FIND.
One way to check whether the Right string value is upper case is to compare the upper case version with the actual value e.g.
If Right(strText, 1) = Right(UCase(strText), 1) Then
MsgBox "Upper Case"
Else
MsgBox "Lower case"
End If
As Paul also has asked, what are you going to do with the strings found?