Thread: Application.Match Ignore Character
View Single Post
  #2   Report Post  
meljunk meljunk is offline
Junior Member
  
Posts: 4
Default
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 View Post
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.
Reply With QuoteReply With Quote