Excel TV ExcelTV
Excel Tips & Tricks

Me vs Bill Jelen on the value of Option Explicit

Updated

Watch me argue it out with the wise and venerable (but ultimately incorrect) Bill “Mr. Excel” Jelen on the topic of using Option Explicit in your code. I argue for the affirmative (that you should use it) while Bill takes the status quo. Let me know your thoughts.

Tags: #optionexplicitvba

Written by

Jordan Goldmeier
Jordan GoldmeierCo-founder, Excel TVFormer Adjunct Instructor, Wake Forest University

Consultant, Anarchy Data · Instructor, Full Stack Modeller

  • Excel
  • Financial Modeling
  • Data Visualization
  • Analytics
Jordan Goldmeier is an accomplished data professional with a wealth of experience across various industries. He currently serves as a consultant at Anarchy Data, where he assists businesses in maximizing the capabilities of Excel for financial planning and analysis. Jordan is also an instructor at Full Stack Modeller and a former Adjunct Instructor in Analytics at Wake Forest University. His extensive career has seen him hold positions as the Chief Operations Officer at Excel.TV, Data Science Manager at DataKind, Data Scientist at Dealer Tire and EY, Analytics & Data Vis Developer at The Perduco Group, and Operations Research Analyst at Booz Allen Hamilton. Jordan's background in data analytics and his passion for Excel make him a valuable resource for businesses seeking to improve their data-driven decision-making processes.

Read more articles by Jordan Goldmeier

Editorial standards

Fact Checking & Editorial Guidelines

Every article on Excel TV is held to a published editorial standard. The goal: accurate, current, and useful — without filler.

  1. Expert review. Drafts on technical Excel topics are reviewed by a contributor with hands-on, working knowledge of the feature being covered.
  2. Source validation. Claims about Excel behavior are tested in current Microsoft 365 builds. Third-party product claims are sourced from the vendor's own documentation.
  3. Disclosure. Affiliate links, sponsorships, and any commercial relationships that influenced a piece are disclosed in-line and at the foot of the article.
  4. Updates. Articles are revisited when Microsoft ships changes that affect the content. The most recent revision date is shown on every post.

Spot a problem? Email editor@excel.tv and we will look at it.

Subject-matter review

Reviewed by Subject Matter Experts

Technical Excel articles are reviewed by contributors with verifiable, hands-on experience in the topic — not generalist editors.

  • Qualified reviewers. Reviewers include Microsoft Excel MVPs, working business-intelligence practitioners, and Excel TV editorial staff. See each author's page for credentials.
  • Current to a known Excel build. Procedural articles state which Excel version they were validated against. Where Microsoft has since changed behavior, the article carries an inline update note.
  • Clarity check. Reviewers verify steps are reproducible by a reader at the assumed skill level — not just technically correct in a vacuum.

Want to contribute or review for Excel TV? See the about page.

Comments (2)

Historical comments preserved from the WordPress archive. Commenting is no longer active.

  1. Ian Wainwright

    Jordan, I’m with you on Option Explicit. It makes you think about the code you write. You had that Mr Excel on the ropes, although I’m not sure he realised it at the time!

  2. Daniel Lamarche - Melbourne AUS

    Option Explicit and declaring my variable properly (with data type) allows me to use Ctrl+ to autocomplete all my variable by typing 3 or 4 characters!
    So Jordan, keep on Option Expliciting!!!!

    Daniel