Share via

Excel VBA Libraries for Mac

Anonymous
2015-01-06T20:06:31+00:00

I'm developing a spreadsheet for Excel that relies heavily on VBA and named ranges.  The file works as intended on Windows and some Mac machines, but there are library conflicts in other Mac machines.

The below problem shows a potential conflict with named ranges:

The following screenshot highlights a possible conflict with the Trim() function, which I am told works with Excel 2011/Mac:

I greatly appreciate any help you can give, even if it means a lot of cleanup on my part.  Thank you in advance.

  • Rob Childress
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
    2015-01-06T22:02:53+00:00

    If there is a missing reference you can have problems with Trim for example, check out what is missing in the list

    Tools>References in the VBA editor

    0 comments
  2. Anonymous
    2015-01-06T22:14:25+00:00

    And, I concur with Ron. The is probably no issue with the TRIM function, but an error elsewhere in the project. make sure all references are properly resolved, and fix all other compile errors.

    0 comments