Sorry, don't have a solution for you but I'm having a similar problem. Just tacking on to your thread to avoid starting a new one.

I'm creating a macro to create graphs from a SAS Proc TABULATE output and I get that error randomly when running my macro. Sometimes it works, sometimes it doesn't. I really don't know what's going on as I just started using VBA a week ago.

Thanks for any insight.