CODEWITHSUNDEEP
excelvba
David Vo
David Vo

Reputation: 65

Random #NAME error only while running macro

I have this workbook that links to another workbook with a simple formula using named ranges. However, there are multiple sheets in this other workbook that uses the same named range. This is one of the formulas

='C:\Account\Onshore'!Account_Balance_USD/'C:\Account\Combined'!Account_Balance_USD

When I open the workbook, this formula will give me a %. But sometimes, while running a macro, the cell becomes #NAME and then I have to press debug, go to this cell and hit enter for it to give me a percentage again. I'm wondering why it does that?

Upvotes: 0

Views: 284

Answers (1)

David Vo
David Vo

Reputation: 65

For all those wondering what happened to this post, like Toddleson said, I had a named range that was being used BUT it was actually connected to a different workbook that was open most of the time but closed sometimes which triggered the "#NAME". It was incorrectly linked since this workbook ALSO had the same named range for itself which I corrected by getting rid of the named range linked to the other workbook.

Upvotes: 1

Related Questions