Share via

Excel Error - Microsoft Visual Basic (VBA) Runtime Error 1004

Anonymous
2025-02-03T17:28:25+00:00

How to resolver Excel Error -Runtime Error 1004

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-02-04T10:41:39+00:00

    Try the following:

    • Activate the Visual Basic Editor.
    • Click in the macro that causes the error.
    • Each time you press F8, one line of the macro will be executed.
    • This should give you an idea which line of code fails.
    0 comments
  2. Anonymous
    2025-02-04T02:14:17+00:00

    I am trying to validate an Excel file (Macros Enabled) with multiple tabs that imports Data from CSV files. After this I am required to validate the file. Upon validation it is supposed to generate a zip file.. However when I try to validate the file it gives me an error message "Modifications Are Not SavedUpload File Not Generated Cannot access ......(here it mentions a particular tab name from within the Excel file that I am trying to validate)".On this message there is button to click OK. On clicking OK it gives a error Microsoft Visual Basic error "Run-time error '1004': Method 'Range of object'_Global' failed. There are two active buttons on this message End and Help. When I click End it displays the Tab which appears in the first error message.

    0 comments
  3. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-02-03T20:39:19+00:00

    Can you post the code, and indicate which line causes the error?

    0 comments