Circular Reference Problem

Hello,

I'm trying to buid a macro to sum several sheets and put the sum in a summary sheet.

The code I've written, is putting the formula in the summary sheet, that is causing trubles since the cells are dependents and causing a circular reference problem.

The aim of my request is to calculate and put in the summary the value withou the formula. Is that possible?

Thanks for your help
Regards,

Please Login or Register  to view this content.