Mac excel error Runtime Error 429 due to CreateObject("Scripting.Dictionary")

[iamstevetay]

Hello Excel Macro Experts!


I'm having an issue with this macro. It was originally written for a Windows machine but I've been forced to work on a Mac and because, from what I understand, Mac Excel doesn't have a scripting dictionary it's not working. I get a Runtime Error 429 when I try to run it, highlighting the CreateObject("Scripting.Dictionary").

Can anyone let me know how to make this script work in Excel Mac?

Thanks,
Steve

Please Login or Register  to view this content.

[Norie]

Perhaps this can help VBA Dictionary.