Type Mismatch
I'm getting the error on "If Not Evaluate...."
Sub Get_CMOP()
Application.ScreenUpdating = False
'Dim Consolidate As Workbook
Dim SWEEP As Workbook
'Dim CMOP As Workbook
Dim CMOP As Workbook
'Dim xLRw As Long
'Dim xCMOPK As Long
Set SWEEP...