@Rick Rothstein
Already some time ago, I've noticed that there are some problems with ArrayList on some computers.
So seeing your post I wanted to check if they persist.
For instance on the computer, I'm using to write this post (new one, purchased Jan 2020, Win10 Home 64, installed as local program Excel for Office 365 MSO, 32 bit, compilation 16.0.12527.20260.
The result of function is just #ARG!
I've tried also early binding version (Added in VBE: Tools-References-mscorlib.dll found in Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.tlb) and tried:
Same result, so changed it into Sub to get a bit better error info:
And now getting at least error info. It's:
Run-time Error '-2146232576 (80131700)' Automation Error
Any hint(s) for me?
Bookmarks