Share via

Error in Excel Macros (Run time error'1004') - MAC User

Anonymous
2022-07-05T08:24:33+00:00

Want to use Macro in Macbook Air to sperate Worksheet, but its is showing error '1004'

Microsoft 365 and Office | Excel | For home | MacOS

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-05T08:56:55+00:00

    Hello, Rahul!

    Thanks for reaching out here regarding this query!

    When you use a VBA code to select a range that is not in the active worksheet, VBA will show you the run-time error 1004.

    Because, if you want to select a cell or range of cells for a particular worksheet needs to be active at that point. You cannot select a cell from the sheet1 if the sheet2 is active right now.

    Hope this helps.

    Warm regards,
    Albert

    1 person found this answer helpful.
    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-07-05T18:45:24+00:00

    Backslash is not a valid character in a file path. Fix the file path.

    0 comments