Hi there

Why does Application.Match or Application.Worksheetfunction.Match
not work with integers as look-up value?

I read there is a difference between both functions ...but coul'n't
get in what way there is a difference...

'fill row1 wihth the numbers 1,2,3,4,5,... and I get a type mismatch,
error 13 on running underneath sub.

Sub test()
Dim sige As Integer
sige = Application.WorksheetFunction.Match("1", "Sheet1!$A$1:$K$1", 0)
MsgBox sige
End Sub