AnsweredAssumed Answered

Resize macro- runtime error 91

Question asked by Matlev on Nov 6, 2017
Latest reply on Oct 4, 2019 by Jarita Sirois

Hi ,

I have been using this resize function for over a year and it worked perfectly until recently.

 

Resize PiDl.JPG

Now it's returning a run time error '91 but only when it's called from Workbook_Open event.

When I call it with a command button or manually in debug mode it works fine.

And when it fails, I can see that the addIn has been set but not the automationObject (="nothing")

I'm using Excel 2016 with Office 365 suite and Datalink 2014 version.

Any help would be much appreciated.

Thanks.

Outcomes