problem with MATCH function

M

Maileen

Hi,

i try to use match to search some value. When i run it, excel displays an
error 13 : type mismatch.

Here is my code:

Set rngCrit1 = ThisWorkbook.Sheets("Backup").Range("G1:G65536")
Set rngCrit2 = ThisWorkbook.Sheets("Backup").Range("H1:H65536")
Set rngCrit3 = ThisWorkbook.Sheets("Backup").Range("K1:K65536")

Dim varTest As Variant
varTest = WorksheetFunction.Match(ThisWorkbook.Sheets("Programs").Range("G"
& iCounter).Value & ThisWorkbook.Sheets("Programs").Range("H" &
iCounter).Value & ThisWorkbook.Sheets("Programs").Range("K" &
iCounter).Value, rngCrit1 & rngCrit2 & rngCrit3, 0)

i do not understand where is the problem.
please, could you help me ?
thx,
Maileen
 
Top