Mismatch error 13 breaking command button

OK not quite so dramatic but darn frustrating....

On a numer of spreadsheets I get a "mismatch error 13" and as a result I am resigned to using two buttons for what should be a single function (and button) as the second function I want to run requires the first to be carried out first....

The mismatch error does not stop the first function working, but does stop the code in its track and pops up the error mismatch message.

I have tried ignore error commands but whilst they stop the pop up the code won't move on to the next string of code successfully. Has anybody had this type of error before and know which ignore error command will not only stop the pop up message being shown but also allow the two functions to run concurrently without stopping?