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.