1,748
reputation
14
20

niton

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

94
answers
0
questions
~321k
people reached
  • Member for 8 years, 9 months
  • 580 profile views
  • Last seen 3 hours ago

Top tags (48)

Score 55
Posts 62
Posts % 66
Score 42
Posts 35
Score 21
Posts 7
Score 8
Posts 29
Score 8
Posts 12
Score 7
Posts 5

Top posts (94)

View all questions and answers

Badges (34)

Gold

Silver

14

Rarest

Bronze

20

Rarest