Runtime error 91: Object variable or With block variable not set

[JohnTaitor]

Hello everyone,

I have a problem with my macro. It always stop on this point (red color):

Please Login or Register  to view this content.

How the Code works
It gets an Array with the Name of the Sheets (Example below) and use it to open it via the function Workbooks.Open, then it will call a function, where the things inside the report will be formatted.

Please Login or Register  to view this content.

Error description:
2019-10-09_7-52-49.png

[mohadin]

Hi
AT least

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

[Norie]

Have you tried using ThisWorkbook instead of ActiveWorkbook?

[JohnTaitor]

Hello everyone,

thanks for all your replies. I tried mohadin`s and bakerman2`s recommendation, but it didnt solve the problem, but after the change from ActiveWorkbook to ThisWorkbook the error message didnt return back

With best regards,
John