Macro only runs from inside sheet not from another workbook/module

Hi,

I have the following macro (not mine, but it works perfectly). The issue I have, is it only works when I embed it in the "Master" worksheet and run it. It won't work when called from another workbook. I am running a series of automated tasks, and this is the last one, so would just like it to happen, so I can automatically save afterward.

If I run from somewhere other than from within the "Master" sheet, it does the first couple of rows, then when it hits a duplicate value, I get a 1004 error "Name already taken" here...

"Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = shName"

Any idea's anyone?

Please Login or Register  to view this content.

Unfortunately neither work. The first one results in the correct worksheets, and names, but only 1 row per sheet, deleteing all the rest.
The second has again the correct sheets, but none of the rows correspond to the correct sheet.

Perfect. Thank you.