Deleting worksheet only replaces worksheet name with a zero "0" number.

Is somebody able to tell me what's wrong with this code here?

I'm simply trying to delete a worksheet in my activeworkbook based off of a variable name located in a cell below.

I feel confident that this should be working based on the way that I have written it, but it's not doing what it's supposed to.

Instead of completely deleting the worksheet, it's only deleting the "name" of the worksheet, and replacing it with zero "0".

Please Login or Register  to view this content.

The code has in fact errors but hidden by the resume next.

Please Login or Register  to view this content.

sName must match the name on a workbook;otherise you will get out of range error

Originally Posted by AB33

The code has in fact errors but hidden by the resume next.

Please Login or Register  to view this content.

sName must match the name on a workbook;otherise you will get out of range error

I figured it out finally.

Basically my issue had to do with me not identifying a cell address selection at the beginning of my code, and then I had to modify it to do a For Each Worksheet function.

It's working great now. Thank you AB33 for giving me the rookie tip of commenting out the On Error so that I could better dig down into what was really going wrong.

Please Login or Register  to view this content.

You could also add exit for line in the sub once the code found the sheet so it will not loop unnecessarily.

Please Login or Register  to view this content.

Originally Posted by AB33

You could also add exit for line in the sub once the code found the sheet so it will not loop unnecessarily.

Please Login or Register  to view this content.

Ooh... great idea!

Thanks again AB33!