1,417 reputation
7 17


Add Option Explicit to the top of your VBA code. Remove unused variables and declare the rest. "On Error Resume Next , is the most commonly used and misused form. It instructs to VBA to essentially ignore the error and resume execution on the next line of code. It is very important to remember that On Error Resume Next does not in any way "fix" the error." http://www.cpearson.com/excel/errorhandling.htm

Top Tags (42)

Score 30
Posts 50
Posts % 63
Score 23
Posts 32
Score 9
Posts 7
Score 7
Posts 5
Score 5
Posts 13
Score 5
Posts 13

Top Posts (79) All Questions Answers | Votes Newest

View all questions and answers

Badges (24)

Silver 7


Bronze 17