Make sure the entire line from "Application" to "lastcell))" is on
one line in the VBE.

In article ,
(AlisonB) wrote:

I get an error message -

Compile Error:

Syntax error

and the code

lastcell.Offset(1, coloffset).Value = _
Application.WorksheetFunction.Sum(Range(firstcell,
lastcell))

is in red.

Does this help spot what is wrong?