Dear All,

I'm running code and I am getting instances when I get ActiveX - can't
create object. When I end procedure I get multiple workbook objects
in my vbProject (named the sheet the procedure was working on).

I think it is to do with the fact I am using the object name of a
sheet to pass it to a function which finds the usedrange.

Please can anyone put some light into why this might be happening?

Thanks

Mac