Write formula in Macro

[bulke]

dear all,

I have a very heavy file with formula across several sheets (linked). I want to insert the formulas which are in a large area into a macro.

How can I insert a formula which will look for data in another sheet and sum them in another.
EX:
There is one sheet per employee which insert their daily task, the task are then compute per hour in another sheet. The weekly total is then computed in another sheet for all employees.
How can I write the formula which will look for the total of tasks per employee: it looks like
=if(iserror(countif(sheet1A1:A5,B1)/sumproduct(countif(sheet1A1:A5,LISTOFACTIVITIES))/1440*,"",countif(sheet1A1:A5,B1)/sumproduct(countif(sheet1A1:A5,LISTOFACTIVITIES))/1440*)

I think I am being pretty vague with giving the above formula...
but if someone could give some tips on how to write a similar formula in a macro for a given range of cell...

Looking forward to your answer.

Cheers

Bulke

 

[TiaXL]

select the cell for the formula in the code and do

activecell.formula = "=formula"

or you can do

activecell.formulaR1C1 which is Row/Column