>Does anyone have an example how to insert sum() function in excel spreadsheet in code? I'm building the spreadsheet in code, and at the end, I want to sum each column.
>
>Thanks
>
>Kirk
loExcelApp.Sheets("Sheet1").Select.cells( 29, 13).FormulaR1C1="=SUM(RC[-4]:RC[-1])"
Carole Shaw
Fred Hutchinson Cancer Research Center
Eagles may soar, but weasels don't get sucked into jet engines.