Trouble with Tutorial (Adding Worksheet to Existing Workbook - VBA)

[bmoff28]

Dear Experts,

I have a problem & a question re: this tutorial on mrexcel.com: http://www.mrexcel.com/articles/macro-to-add-daily-report.php. I'm trying to utilize this in a PO system for work. Unfortunately, I keep receiving a Run-time error '9' (subscript out of range) on this specific line:

Sheets(TabName).Copy After:=Workbooks(ControlFile).Sheets(1)

The code is strictly copy/pasted into my VBA editor, except changing the names inbetween each of the quotes ("") for specific sheet/cell names. I'm not a programmer, but I've read through the code and logically can't deduce why it shouldn't work for me.

My other related question is that I would like to have the new worksheet sent to the end of the active workbook, so would substituting "Sheets(Sheets.Count)" at the end of the above line of code work to send it to the end of the workbook?

Thanks for your help ahead of time.

 

[bmoff28]

I was really just copying the tutorial with some minor tweaks to fit my needs. But thanks for the tips, I'll try to simplify per your example.