in some cases the macro freezes - need to handle the error

[netanel99]

hello excelers,

the macro works, but sometimes due to not proper use of it , I get an error - than all the excel file collapse ,
In this case I really want that if the code seeing on front that this is gonna be an error so It won't do nothing, and not continue with the macro, just ignore the execution of the macro in case of an error, is it possible ?

 

[netanel99]

sorry I think I need to readjust my question : my macro works if I've copied something before, but If I don't have nothing in store - means, I didn't copied nothing so the macro will collapse,
how can I have a macro executed only if before the execution I've copied something .

thanks for any help you guys .