String search in a specific location

[vnarla]

Hi,

Could someone help me with this issue? I am trying to find the number "5000" in a column of data, but in a specific location. The specific location is between digits 1 through 4 or 3 through 6.

The row marked in red is a result of my code looking in the wrong location. I hope this made sense.

My line of code:

Please Login or Register  to view this content.

Thanks

Vinnie
2013-01-24 14_42_01-Document1 - Microsoft Word.jpg

[Leith Ross]

Hello vnarla,

Welcome to the Forum!

The InStr method returns the starting position of the string if it is found. You need to check if the return value is 1 or 3.

Please Login or Register  to view this content.

[vnarla]

That trick worked like a charm. Thanks Leith!

I will keep the formatting in mind for the future.

Vinnie