Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Dim s As String
Dim lRow As Long s = "123456" lRow = Application.Match(s, Application.Substitute(Range("A1:A1000"), ".", ""), 0) Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array, Match, Ignore and List | Excel Programming | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
How do I ignore a character in a cell? | Excel Programming | |||
Application.Min - how to ignore zero value? | Excel Programming | |||
How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) |