Look for a sequence of numbers and letters in a Cell value

[JazzSP8]

Hi All

Scratching my head a bit with this one.

I've code that loops through some cells and look for a certain sequence of letters and numbers and if found, copies it.

The sequence used to just appear as the first 7 characters so I could just check for it there, however a recent change to another system has made it so it can appear seemingly anywhere.

The code already works so it's literally just how to look for the sequence I'm struggling with. In an ideal world I'd be able to do this;

If InStr(Cells(i, "A").Value, Like "[A-Z][A-Z]#####") <> 0 Then

But this isn't an ideal world

Any help?

 

[steve the fish]

Try:

If Cells(i, "A").Value Like "*[A-Z][A-Z]#####*" Then

 

[JazzSP8]

That seems to do the trick! - Thanking you Good Sir!