Excel for Mac - Runtime Error '91': Object variable or With block variable not set

Question

Hello,

When attempting to run an Excel macro I receive the error message Runtime Error '91': Object variable or With block variable not set.

The macro is not created by me but the source is trustworthy and I know that it works on PC. If shared via OneDrive it works a PC but not on the Mac. How can I solve this?

Thanks!

Answer 1

I would assume this is the case then, that the code is not compatible with Mac. Are there any guidelines on how to create a code compatible with both Mac and PC?

Hi Linda,

No, the problem is generally simple:

Sometimes you need to do special tasks which are not possible using VBA and/or what Excel provides. In Windows there are many external DLL files, which are libraries that export functions, inside the system folder which we can access / use to do this tasks.

A Mac does not have this structure and does not provide it because of its security concept.

Therefore, many things are not possible on a Mac.

Andreas.

Answer 2

Depends on the VBA code... but in most cases the code is not compatible with a Mac and therefore the file is not compatible with your Mac.

Andreas.

Answer 3

Hi Linda,

Greetings! Thank you for posting to Microsoft Community.

There are two steps to creating an object variable. First you must declare the object variable. Then you must assign a valid reference to the object variable using the Set statement.

Object variable not set (Error 91) | Microsoft Learn

Share your code will help to check your issue.

Best Regards,

Snow Lu

Answer 4

Hello Andreas and Snow,

Thank you for the quick replies.

I would assume this is the case then, that the code is not compatible with Mac. Are there any guidelines on how to create a code compatible with both Mac and PC?

It would be great to be able to let the supplier of the code know this so that they instead can provide a file with a code that is compatible also for Mac.

• Linda