VBA Worksheet select error.

Hi, I attached my workbook so you guys can easily take a look.
In this workbook I have 2 hidden worksheets.

To start off, you click the Add Week button, put in a date (mm-dd-yy), that brings up the sheet thats named with the date you just put in the text box. (Which happens to be placed in the wrong spot) In that sheet that appears theres a button to "Delete last" which is suposed to delete the last sheet in the worksheet but the new sheet gets placed between the existing charts. Thats my first problem.

Next, when you hit the delete button, my VBA code is set to make one of the hidden sheets visible so it can delete one of the rows.

Please Login or Register  to view this content.

Its fine deleteing the row, but when I go back and select this sheet again I get an error with the selection.

Please Login or Register  to view this content.

even though I have the exact same line of code just before and it doesnt give me an error.

Heres a snipet of the code but you guys can take a look at the actual file for the full thing.

Please Login or Register  to view this content.

I wrote this last year and havent used excel since so my understanding of the code is less then optimal.

The Total WO Table does not get deleted, it gets moved then selects the last sheet. But it has Worksheets(Worksheets.Count).Select so it selects the absolute last sheet created which is always one of the datasheets.

Delete the last data sheet, not the chart. If you could get it to delete the current sheet that the macro button was pressed on that would be great, thats probably what I need to work towards.

Deleteing the sheet is fine, its combining everything where Im getting an error. The error I get is when I try to make a sheet visible, Im not trying to delete it and its not getting deleted and its not like you get an error when you try to make a sheet visible thats already visible. But thats what its giving me an error and I dont know why.

Do you get any errors when you run my original code?