HI all. Hoping you can help.
So, if Cell H1 says Complaint I want to run the NetworkDays formula between 2 date fields P1 & R1. I’ve got the below, but it’s a bug.
ActiveCell.FormulaR1C1 = _
"=IF(ISERROR(SEARCH("Complaint",H1)),"",NETWORKDAYS(P1,R1,'[VlookUp lists for...