niton's user avatar
niton's user avatar
niton's user avatar
niton
  • Member for 11 years, 7 months
  • Last seen more than a month ago
Stats
1,816
reputation
402k
reached
96
answers
0
questions
Loading…
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

This user doesn’t have any gold badges yet.
15
silver badges
23
bronze badges
62
Score
65
Posts
68
Posts %
44
Score
35
Posts
36
Posts %
23
Score
7
Posts
7
Posts %
11
Score
32
Posts
33
Posts %
8
Score
11
Posts
11
Posts %
7
Score
21
Posts
22
Posts %
Top posts
View all questions and answers