Ref error on VBA Range.formula

Hi,

I have a working macro that copies over a sheet to a new workbook.
It then inserts the formula "=sum(Debtors!I:I)" into range g19 in worksheet directors checklist.
However, this returns a #REF! error.

I would understand this error if the reference was wrong but it is correct.
When i press F2 to enter the cell and then enter, the formula works correctly and the #REF! error disappears.

Can someone explain what's wrong and how to fix it?

Please Login or Register  to view this content.

Originally Posted by than_gold

Try without formula & check auto-calculation is enabled?

Hi,

I found the problem. The ref error was correct.

It is due tot he fact that the formula is entered before the debtor sheet is added.