I added this array line to the following and the code stopped working
Can you have more than 1 array line?
I'm basically checking is C6 contains the words "AO Supervisor" or CF Supervisor"
Code: Select all
sFile & "C6,{""AO Supervisor"",""CF Supervisor""}," & _
Code: Select all
With wsh.Range("G438:CD439")
.FormulaR1C1 = _
"=SUM(SUMIFS(" & sFile & "C12," & _
sFile & "C8,""=""&RC2," & _
sFile & "C7,""=""&R1C4," & _
sFile & "C13,""=""&Month(R12C)," & _
sFile & "C14,""=""&Year(R12C)," & _
sFile & "C1,"">""&R5C2," & _
sFile & "C3,""<>""," & _
sFile & "C4,""<>""," & _
sFile & "C11,""Yes""," & _
sFile & "C9,""Permanent""," & _
sFile & "C6,{""AO Supervisor"",""CF Supervisor""}," & _
sFile & "C5,{""Rehire"",""External"",""Internal Requisition- Same Workgroup, Status, Station"",""Internal Requisition""}))"
.Value = .Value
End With