I can assign a value to a String - Dim strUnit = "1-1 CAV SQDN" - and use that as a filter. What I would like to do is use the Like "*1-1 CAV*" type function.
I want the code to search ......range(irow, 4) = strUnit
Ranges I have
1-1 CAV SQDN
A TROOP, 1-1 CAV SQDN
B TROOP, 1-1 CAV SQDN
C TROOP, 1-1 CAV SQDN
D TROOP, 1-1 CAV SQDN
D CO (FSC), 1-1 CAV SQDN
If I use Dim strUnit = "1-1 CAV SQDN" I only get whats = to 1-1 CAV SQDN in Column 4
VBA doesn't care for Like.
with Dim strUnit Like "*1-1 CAV*" I get an error.
What is the correct way?
I have tried StrUnit "1-1 CAV SQDN" Like "*1-1 CAV SQDN*" and StrUnit "*1-1 CAV SQDN*" Like "1-1 CAV SQDN", the out put is as if I used strUnit = "1-1 CAV SQDN"
Can someone clarify please?
Thanks
Wayne