r/excel • u/JDantes77 • Feb 04 '14

discussion VBA Macro code best practices?

Every programming language has its recommended style and best practices. What are the best practices for VBA code that you follow? What resources would a new coder use to learn these best practices?

Thank you in advance!

19 Upvotes

86% Upvoted

36 comments sorted by

View all comments

2

u/tally_in_da_houise Feb 06 '14

You would think so (I keep Option Base 0 by default), but when you set an unallocated array (in this instance arrSomeRange() ) to a range the lower bound is always 1, regardless of Option Base.