Macro Stopped Functioning

Hi Everyone,

Some time ago this forum helped me develop a macro for a workbook I have been developing. Recently I made some changes by renaming the workbook sheets and then updated the macro accordingly. When I ran it yesterday, I received a debug error. I made some additional tweaks to the macro which resolved some of the issues, but I am still getting the debug error and haven't been able to figure it out. Any help is appreciated.

I have included a sample of the workbook with the relevant sheets. If you go to the Developer tab and click on macro you can get to the error by clicking Edit for the "Sample.xlsm!MakSubScriptPrint4.MakSubScriptPrint4" option in the Macro dialog box. The error comes up when you click run within the "Sub MakSuperScriptPrint4 ()" macro. The error seems to pertain to the "Else" line, which gets highlighted when clicking debug after running the macro. I have not been able to figure out what is going on here. I changed the sheet names from Print2 & Print4 to Material Properties & Alt. Section Properties, respectively. The macro is supposed to delete the text in the indicated cells when a non-topped product is selected. I'm also noticing that the "Sub MakSubScriptPrint4 ()" is not clearing all of the text when running the macro for non-topped products.

I've tried to be brief in my explanation of the issue, but clear enough that I can get some feedback. Feel free to ask additional questions for clarity. Thank you in advance for your help.

Matt

AlphaFrog,

Thank you for your prompt response. I figured it was something simple, but I couldn't see it.

Matt