Hi there,
If by "they don't seem to work" you mean that a Syntax Error message is generated then try:
For Z = 4 To lastrowG
If data.Cells(Z, 147).Value = vbNullString Then
data.Cells(Z, 148).ClearContents
ElseIf data.Cells(Z, 154).Value = "F" Or data.Cells(Z, 154).Value = "FI" Or data.Cells(Z, 154).Value = "TC" Then data.Cells(Z, 148).ClearContents
ElseIf data.Cells(Z, 147).Value = "Duplicate" Then data.Cells(Z, 148).ClearContents
ElseIf data.Cells(Z, 148).Value = "Yes" And data.Cells(Z, 159).Value = vbNullString Then data.Cells(Z, 159).Value = "NA"
End If
Next Z
The worksheet function "IsBlank" doesn't seem to be available in VBA.
I'm assuming that your workbook contains a worksheet whose CodeName (not Tab name) is "data"
Hope this helps.
Regards,
Greg M
Bookmarks