Run-Time error

[billandrew]

receiving a run-time error on some provide vba code not sure why?

Active X Component can't create object.

Any help would be appreciated.

Thanks

 

[Norie]

Can you post the code and indicate where you get the error?

 

[billandrew]

There is no line visually where the error occurs.

 

[billandrew]

I do not currently have access. The code is located in ThisWorkbook as opposed to a module. Could this be the issue?