April 13

Me vs Bill Jelen on the value of Option Explicit

2  comments

Me vs Bill Jelen on the value of Option Explicit

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.

Loved this? Spread the word


About the Author

Jordan Goldmeier

Related posts

Oz’s Excel Tip: Keep a Workbook for Random Data in Excel

Read More

How to create a relative file path in Power Query

Read More

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Read More

Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55

Read More
  • 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!

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Subscribe to our newsletter now!

    >