in reply to Not able to create worksheets inside a subroutine
Note: this appears to be a near duplicate of Scope of workbook in write excel.
--MidLifeXis