rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hi,
I need to identify the first two digits of an 8 digit number and if it is "87", then populate another column with a value "GF".
I need to use VBA and not VLookup, since I have other codes in the same module.
My code is
obviously failed at the LEFT functionality!
I need to identify the first two digits of an 8 digit number and if it is "87", then populate another column with a value "GF".
I need to use VBA and not VLookup, since I have other codes in the same module.
My code is
Rich (BB code):
LastRow = ws.Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Left(ws.Range("AI" & i), 2).Value = "87" Then
ws.Range("BE" & i).Value = "GF"
End If
Next i
obviously failed at the LEFT functionality!
Last edited by a moderator: