cortexnotion
Board Regular
- Joined
- Jan 22, 2020
- Messages
- 150
- Office Version
- 2013
- Platform
- Windows
Hi All
I next to check column 9 and filter if the 5th character is a number or text, but I can't get the syntax right... I'm trying:
and
Any guidance appreciated. Thanks!
I next to check column 9 and filter if the 5th character is a number or text, but I can't get the syntax right... I'm trying:
VBA Code:
For a = LBound(ArrIN) To UBound(ArrIN)
If IsNumeric(Mid((a, 9), 5, 1)) Then
and
VBA Code:
For a = LBound(ArrIN) To UBound(ArrIN)
If IsText(Mid((a, 9), 5, 1)) ThenThen
Any guidance appreciated. Thanks!