Help w/ Vlookup VBA

[BIGTONE559]

Good Morning.

I seem to be having issues with the syntax using the vlookup formula.

the code is as follows:

Sub Avlookup_Test()

Dim x As Integer
Dim y As Integer
Dim z As Variant

x = 6





Do Until x = 25




If Application.WorksheetFunction.VLookup(Range(Cells(x, 4)), Range("checklist"), 2, False) = Cells(x, 2) Then



MsgBox ("This Value is Correct")





Else
MsgBox ("This value is incorrect")

End If

x = x + 1



Loop


End Sub

The code is supposed to check values on the current sheet with a range on another sheet.

Any help is appreciated.

 

[BIGTONE559]

Forgot to put that i'm receiving

Runtime error 1004
Method 'Range' of object'_Global' failed

when i attempt to run the macro

 

[BIGTONE559]

was anyone able to find anything? using vlookup via vba