Hi,

I'm trying to sum the same cell across a number of
worksheets using the following formula

=SUM(aaa:bbb!C1)
where aaa is the name of the first sheet, bbb is the name
of the last sheet and C1 is the cell being summed...
this works - but what I want to do is replace bbb with a
variable using the INDIRECT function. This means that I
can add sheets onto the end of the workbook (using VBA)
and by updating a single cell (again using VBA) all the
SUM formulas will now add through to the final sheet.

Can't get the syntax to work....any help appreciated

Rgds....Chris