IF then NetworkDays formula

[Dec100]

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 Reports.xls]Workdays'!$A$2:$A$47),0)"

Any thoughts?

 

[wideboydixon]

You're using FormulaR1C1 but your formula is using normal references. Try this:

ActiveCell.Formula = "=IF(ISERROR(SEARCH(""Complaint"",H1)),"""",NETWORKDAYS(P1,R1,'[VlookUp lists for Reports.xls]Workdays'!$A$2:$A$47),0)"

WBD