ActiveCell.Formula Syntax Error

Hey Guys,

I am having trouble using the Sum function over multiple sheets.

What I want to do is take numbers from two different sheets and place the sum on another sheet.

Here is the code I have currently that isn't working:

Please Login or Register  to view this content.

Is there an easy way to specify the cells on different sheets using this syntax?


Thanks!