jeudi 5 juillet 2018

Nested if statements - error 1004

I have problem with my simple VBA code. I have multiple nested if statements (should be included in cells), but unfortunately Im struggling with 1004 error - application defined or object error.

Do you know where is the problem?

rejected = "=IF(ISNUMBER(SEARCH(""rejected permanently"", C2)), ""REJECTED"", 
IF(ISNUMBER(SEARCH(""unproc.""), D2), ""NOT POSTED"", 
IF(ISNUMBER(SEARCH(""NOT POSTED"")), 
IF(ISNUMBER(SEARCH(""Accepted"", D2)), ""Returned Approved Workflow"", 
IF(ISNUMBER(SEARCH(""declined"", D2)),""Returned Rejected Workflow"", 
IF(ISNUMBER(SEARCH(""Called"", D2)), ""Recalled Workflow"", 
IF(ISNUMBER(SEARCH(""succesfully"", C2)), ""POSTED"","""")))))))"

Range("A2:A" & Cells(Rows.Count, "G").End(xlUp).Row).Formula = rejected

Aucun commentaire:

Enregistrer un commentaire