Export data to Excel within functions

[schmitzpm]

I have to export data to a excel worksheet. It is not the problem to export the data and format it, but i have to set some functions in some cells.

When I write

  chWorkSheet:Range(cRange):VALUE = '=SUMME(E2:E329)'

I get

#NAME?

written in the cell.
If I dbclick the cell and click into another one, the function works.
What I have to do to make it work.

 

[schmitzpm]

I found the mistake. I had to use

chWorkSheet:Range(cRange):VALUE = '=SUM(E2:E329)'