Application.Match failing to match numeric values

Hi All
I have a macro to compare two worksheets and report any differences.
The macro will search for a particular value in each row, and check to see if it exists on the other sheet.
I'm using application.match as follows:
varSResult = Application.Match(strSearchText, rSearchRange, 0)
The match works fine for any text values, but all numeric values throw an error (i.e. no match), even though they exist in both sheets.
I'm sure this is a formatting thing but what am I doing wrong? I want to search all values as strings, even if they're purely numeric.
Do I need to use another function or is there a way to get match to do what I want?
TIA
Si

First, if you dimension the variable "strSearchText" As String, then change its type to Variant,
Then add one line

Please Login or Register  to view this content.

No change unfortunately with this:

Please Login or Register  to view this content.

Anything where strITSN is purely numeric fails. Using .find works, but I need to know the row the match took place on.

.... and fixed. Declaring strITSN as a variant rather than a string fixed it.
I suspect I misunderstood your answer - apologies if so.