Issue with Formula

Hi
YOur modification is not correct. It is a loop where value of "a" changes from 1 to 50 (or whatever the no of sheets you have). cell A1 keeps on accumulating (or totalling) C11 with every cycle adding value from one sheet. Use the original code
Ravi

Hi,

Okay, thanks for that.

In relation to the the cell range (recap worksheet) that I want to populate it goes from cells C4:C34 Therefore would a modification of the macro be required to pre-populate those cells?

Thanks

HI
try this modified macro

sub total()
dim a,b as integer
Range("A1:A31).clearcontents
for b =  4 to 34
for a = 1 to sheets.count
cells(b-3,1) = cells(b-3,1) + worksheets(a).cells(11,3)
next a
next b
end sub

Ravi

Hi,

Thanks for that; however, I have a syntax error on the following line:

Range("A1:A31).clearcontents

Any thoughts?

youve just missed " mark after the second cell value