trying to use a command button on excel to add a new worksheet. but now that i am trying to address user inputs that would cause and error im getting a compile error. i know its something simple but i am just missing where i am messing up.
error on the prodecure
i want to account for users not naming the sheets or canceling out of it but as soon as i added the errhandler i got a compile error
New contributor
StitchUS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1