writing "=sum" function form vb to excel
Posted on 2004-08-15
trying to write =sum function from vb to sum some of the cells in excel
when i write
.Cells(10,13).Formula = "=SUM(C13,E13,G13,I13,K13,M13,O13,Q13)"
the above statement writes the string as it is it writes =SUM(C13,E13,G13,I13,K13,M13,O13,Q13 in the specified cell (10,13)instead of calculating the value from the given cells. Can some one tell me how to do this please see that the cells are from alternate columns but in the same row.
thanks in advance. Its kind of urgent