Applescript, Excel & Sum a range

[distended]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I am attempting to set the value of a cell at the end of a range to the sum of the cells in that range.

The row location is a variable but the column is constant.

This is my lame attempt at the code:set value of cell d of column c to sum of ranges (d of column 55) through (d of column 79)

When I compile this code the sum text color becomes green, indicating applescript is assuming it is a variable and not a function.

Any help would be appreciated.

Thanks!

 

[distended]

This works...

set formula of cell d of column c to "=SUM(RC[-24]:RC[-1])"

 

[Theo Olsthoorn]

I can't write function in Mac Excel, this makes the program useless to me
and I have to switch back to Windows-Excel

url:http://www.ureader.com/msg/15902646.aspx