Random NAME error only while running macro

0 votes

I have a worksheet with a named range formula that relates to another workbook. However, this other workbook utilizes the same named range on several sheets. One of the formulas is this one.

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

I'll get a% from this formula when I open the workbook. But occasionally, when a macro is executing, the cell changes to #NAME, and I have to press debug, navigate to this cell, and press enter to get the percentage back. I'm curious why it acts in that way.

Dec 28, 2022 in Others by Kithuzzz
• 38,000 points
440 views

1 answer to this question.

0 votes
For those who are wondering what happened to this post, as Toddleson mentioned, I had a named range that was being used, but it was actually tied to another workbook that was typically open but occasionally closed, which caused the "#NAME" to be triggered. Since this workbook ALSO had the same named range for itself, it was wrongly linked. I fixed it by removing the named range that was connected to the other workbook.
answered Dec 29, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
3 answers

Error while joining cluster with node

Hi Kalgi after following above steps it ...READ MORE

answered Jan 17, 2019 in Others by anonymous
15,553 views
+1 vote
0 answers

where to put tf files while building servers from terraform.. its creating only workspace.

# kitchen create -----> Starting Kitchen (v2.2.5) -----> Creating ...READ MORE

Aug 4, 2019 in Others by Priyanka
610 views
0 votes
1 answer

The uploaded file exceeds the upload_max_filesize directive in php.ini error while uploading plugin

After looking at your ERROR, it seems ...READ MORE

answered Feb 8, 2022 in Others by Soham
• 9,710 points
695 views
0 votes
1 answer

Session 'app' error while installing APK

In order to overcome this problem, start ...READ MORE

answered Feb 22, 2022 in Others by Aditya
• 7,680 points
714 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,246 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,692 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
955 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,084 views
0 votes
1 answer

Runtime error 438 while importing data in excel from secured website using VBA

Replace With ieDoc.forms(0) .userType.Value = "1" ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
908 views
0 votes
1 answer

VBA code to select only a table. I am getting a Run-time error '1004'; Method 'Range' of object'_Global' failed

No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE

answered Jan 13, 2023 in Others by narikkadan
• 63,600 points
1,157 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP