Hi
I am trying to change an array formula via code, using the following code, basically adding *(Assumed FTE)* after the Contractor=Yes criteria.
This gives a formula like
=SUM((tblEmployees[Type]='Resource Planner Data'!$A7)*(tblEmployees[Contractor]="Yes")*(tblEmployees[Assumed FTE])*(tblEmployees[Start]<'Resource Planner Data'!F$2)*((tblEmployees[End]>'Resource Planner Data'!F$3)+(tblEmployees[End]="")))*$C$4
But the error of
Unable to set the FormulaArray property of the Range class on this line
c.FormulaArray = strNewFormula
Many thanks
Nathan,
Bookmarks