Hello all,

I was trying to use the Match function in a VBA module (I hate VBA).
Match was failing unexpectedly.

I evenetually tracked down one issue (using Match in a normal worksheet
not in a module).

If the tilda ('~') character is in the cell I am trying to match I will
not get a match.

I tested this by:
1) making a small column array from A1:A6
a
b
c
d
e
f

2) In cell B1 entered 'c'
3) In cell C3 entered '=Match(B1, A1:A6, 0)' - the correct result of 3
appeared in cell C3
4) I edited cell A4 to 'd~' and copied and pasted this cell to cell B1 -
no match returned #N/A

I tried other forms such as '~d' etc and they failed. I didn't try many
other unusual characters.

A simple =IF function did say the cells were the same.

Is there any way of dealing with this in my script and/or on a worksheet
(otehr than the obvious iteration over all elements and test with For and
If statements).

Thanks,
Ian