Dim s As String
Dim lRow As Long
s = "123456"
lRow = Application.Match(s, Application.Substitute(Range("A1:A1000"), ".", ""), 0)
Quote:
Originally Posted by meljunk
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.
|
Similar Threads
Hybrid Mode
