Skip to main content
1 of 4
Máté Juhász
  • 21.9k
  • 13
  • 25

general troubleshooting tips for excel formula and VBA

I'm interested mainly in excel and VBA, reading a lot of questions in these topics.
I often find questions like "formula doesn't work", "what is the problem with this code" for which there are a couple of things the asker should check, and these are generally asked in comments quite quickly (have you double checked that your output is really wrong? Have you tracked your formula, if yes where it fails? Which line of code gives the error message and what it is? Have you checked the values of the relevant variables in the immediate window? Not the same, but similar comment: Please make some effort to solve your problem, we aren't a few code writing service...).
It would be useful to have an article in help to which e can just refer in case of missing information instead of typing sentences each time.

Máté Juhász
  • 21.9k
  • 13
  • 25