resume

I want to put some error checking in my code but I can't seem to figure out how to have multiple "On Error Goto XXX" statements in the same Sub. Someone said to place "Resume" statements in the code but I can't figure out how to make it work. Below are 2 "On Error" statements. The line...

Hi, I have a timer function that counts down, however I need to add a pause button and function. Can anybody advise on the code to pause the count down. the code for my timer is:- Sub Makechange() Dim PauseTime, Start Do PauseTime = 1 ' Set duration. Start = Timer ' Set start...

Excel 2002 Below is my code that will create a new tab for the current month for each workbook in a folder. Sometimes there will be a workbook in the middle of a folder that will generate an error so I would like to be able to correct the error in the code but then re-run the macro. So I need...

I have some code which basically consolidates all worksheets from a workbook into the first sheet. It has on error resume next so it can continue the code after consolidating. I need to add an error messagebox that appears if the code can't find the correct reference file open. How can I add...