niton's user avatar
niton's user avatar
niton's user avatar
niton
  • Member for 10 years, 2 months
  • Last seen this week
Stats
103
reputation
261
reached
0
answers
3
questions
About

Add Option Explicit to the top of your VBA code. Remove unused variables and declare the rest. https://excelmacromastery.com/vba-error-handling / "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

Badges
This user doesn’t have any gold badges yet.
1
silver badge
5
bronze badges
0
Score
1
Posts
33
Posts %
0
Score
1
Posts
33
Posts %
0
Score
1
Posts
33
Posts %
0
Score
1
Posts
33
Posts %
0
Score
1
Posts
33
Posts %
0
Score
1
Posts
33
Posts %
question
0
Nov 22, 2013
question
0
Dec 7, 2013