VBA works for some but not others

[cheesiepoof05]

I created a workbook with quite a bit of VBA that multiple people use just fine. There are a few people that get the following error when they try to kick off a macro.

The debug highlights the below as the error.

ActiveCell.Formula2R1C1 = "=SORT(UNIQUE('Specialty Report'!R12C1:R30000C1))"

Any ideas on why many users can run it without issues, but some users errors out?

Everyone is selecting "Enable Content" when they get the Security Warning: Macros message.

 

[JLGWhiz]

Most likely a version problem. If they are not Running 365 or later version of Excel then the SORT and UNIQUE functions may not be available on their systems. Choices are to upgrade their systems or revise the code to accomodate their version of Excel.