Application.Match Ignore Character
 

Hi all,
I want to run a Match however the values in my Spreadsheet may contain a "." that I want to ignore e.g.

Search Text= "123456"
Value in Spreadsheet = "123.45.6"

atRow = Application.Match("123456", ws.Range("A1:A1000"), 0)

So basically if there is a "." in the rows I'm searching I want to ignore them. I do not want to alter the Spreadsheet though.

Thanking you in advance.

Dim s As String
Dim lRow As Long

s = "123456"
lRow = Application.Match(s, Application.Substitute(Range("A1:A1000"), ".", ""), 0)