Runtime Error Type Mismatch

For some reason this code works at home two test files, but when running at work I get this error. The macro loops through a list of sheet names in the macrobook and in the wb2 it should select all cells and copy paste as values, which doesn't happen because of this error. Then it deletes all sheets if the sheet name is not in the list in the macrobook. It does delete the sheets properly. Maybe the solution would be to add another code that loops through the remaining sheets and copy paste as values? Or does someone know what I'm doing wrong here.

Please Login or Register  to view this content.

Originally Posted by Norie

Are there any errors in any of the cells in any of the worksheets?

No errors in the cells of the worksheets. Also the code in asterisk is the part that I need to debu.

I'm not sure as I had help with this code. I think it's checking to see if the value in the cell is blank, and if its not, then it takes out any spaces if the cell value starts with spaces? If it's difficult to pinpoint the issue, is there a way to modify this code to get it to work?