formula error, working but stops code

The Sub MTW_Rating() actually enters the correct formula and copies down - but then it gives an error and stops the code.
Can someone take a look?
The code should be running on sheet "Report".
I attached the workbook ....
test.xlsb
Euro5Asked:
Who is Participating?
 
Rgonzo1971Commented:
HI,

pls try
        .Range(.Cells(2, NextCol), .Cells(LastRow, NextCol)).Formula = _
"=IF(" & RWt & "2<200,VLOOKUP(200,MWT," & Zn & "2,TRUE),VLOOKUP(" & RWt & "2,MWT," & Zn & "2,TRUE))"

Open in new window

Regards
0
 
Euro5Author Commented:
Thank you!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.