Error: unable to get the match property of the worksheet function class

[punno]

Dear Good People,

I am having this error message: unable to get the match property of the worksheet function class. Below is my code where iam getting These Problem. Let me know what should i corret.Thanks

For i = 15 To 1000
If Worksheets("Sheet1").Cells(0 + i, 6) > 3 Then
'Worksheets("Sheet1").Cells(0 + i, 7) = "=INDEX('Known issues'!$A$3:$H$1000,MATCH('Known issues'!H28,'Known issues'!$F$3:$F$10,0),3)"
Worksheets("Shet1").Cells(0 + i, 7).Value = Application.WorksheetFunction.Index(Sheets("Known issues").Range("$A$3:$H$1000"), Application.WorksheetFunction.Match(Sheets("Known issues").Cells(i - 12, 8).Value, Sheets("Known issues").Range("$F$3:$F$10"), 0), 3)
End If
Next i




Best Regards,
Punno

 

[punno]

It doesnt give any value , completely blank.i wanted to use the for Loop thats why i used worksheet function to use cells.

One correction. It does give right value for all the cells where the condition met.After that this error message Shows up and when i press debug it Point out to the lne after the if condition

 

[Fluff]

Which is exactly what I pointed out in post#5
Try

   Dim x As Variant
   For i = 15 To 1000
      If Worksheets("Sheet1").Cells(0 + i, 6) > 3 Then
         x = Application.Index(Sheets("Known issues").Range("$A$3:$H$1000"), Application.Match(Sheets("Known issues").Cells(i - 12, 8).Value, Sheets("Known issues").Range("$F$3:$F$10"), 0), 3)
         If Not IsError(x) Then Worksheets("Sheet1").Cells(0 + i, 7).Value = x
      End If
   Next i
End Sub

 

[punno]

What is the value of i when the code fails?

It finishes the Loop to 1000.then gives the error message

 

[Fluff]

What is the error message & row is highlighted when you click debug?

 

[punno]

What is the error message & row is highlighted when you click debug?

Sorry it stops at 300 Iteration and Shows error message "unable to get the match property of the worksheet function class"

 

[Fluff]

In that case please post the code you are currently using.