&'s and ":"'s and ","

Posted by paige on February 02, 2001 4:59 AM

i want to set the cell (Wdcount, Wdcol) to be the formula MOYENNE (this is average in french excel) of cells from (startmonth, Wdcol) to (copywdcount, Wdcol)
I am getting an error tho and i think it is the various "",,,&&&. i do not have a good reference to know what the syntax should be.

thanks in advance

Worksheets("Sheet1").Cells(Wdcount, Wdcol).Formula = " =MOYENNE(startmonth,Wdcol & : & copywdcount, Wdcol )"

Posted by Gregc on February 02, 2001 8:06 AM

Try this
Worksheets("Sheet1").Cells(Wdcount, Wdcol).Formula = "=MOYENNE(startmonth,Wdcol" & ":" & "copywdcount, Wdcol )"

Posted by Tim Francis-Wright on February 02, 2001 1:24 PM

I don't think that will work. Try this (tested en Anglais) --

Worksheets("Sheet1").Cells(Wdcount,Wdcol).Formula = "=MOYENNE(" & Cells(startmonth,Wdcol).address & ":" & cells(copywdcount, Wdcol).address & ")"

Good luck!