itipu
02-11-2008, 04:55 AM
I have Column "A" where data is like this:
mik-n-t12121
bob-n-s12121
don-n-d12121
Around 5000 lines....
I want something like this:
Dim c as Range
sizera = ActiveSheet.UsedRange.Rows.Count
For Each c In ActiveSheet.Range("A2:A$" & sizera)
'IF c.Value 1ST CHARACTER AFTER 2ND DASH = t THEN ....
Next c
So far struggling with the best way of identifying 1ST CHARACTER AFTER 2ND "-" is t THEN
Thanks a lot
Mike
mik-n-t12121
bob-n-s12121
don-n-d12121
Around 5000 lines....
I want something like this:
Dim c as Range
sizera = ActiveSheet.UsedRange.Rows.Count
For Each c In ActiveSheet.Range("A2:A$" & sizera)
'IF c.Value 1ST CHARACTER AFTER 2ND DASH = t THEN ....
Next c
So far struggling with the best way of identifying 1ST CHARACTER AFTER 2ND "-" is t THEN
Thanks a lot
Mike