Quick Note on Formatting = Because StackExchange uses [Markdown][1] and [Prettify.js][2] it is possible to add a language flag to your coding answers, which generally makes them look more professional. While I cannot guarantee that this will make you any better at golfing in VBA, I can guarantee that it will make you look like you are. Adding either of the flags below will transform Public Sub a(ByRef b As Integer) ''# this is a comment to <!-- language: lang-vba --> Public Sub a(ByRef b As Integer) ''# this is a comment _Note: there seems to be a bit of an error with the way that Prettify.js handles VBA, in that it assumes the literal `#` (the character used to indicate conditional compilation) to be the comment character, rather than `'`, which is handled like a char literal character. Because of this, I recommend starting comments with `''# ` when using prettify.js as it looks correct both to the compiler and to prettify.js_ __VBA Language Tags__ `<!-- language: lang-vba --> ` `<!-- language-all: lang-vba --> ` _Note: the latter transforms all code segments in your answer, while the prior transforms only the immediately following code segments_ _Note, The Second: If you happen to be looking for VB or VBScript tips here, you can use `lang-vb` or `lang-vbs`, respectively for highlighting_ [1]: https://en.wikipedia.org/wiki/Markdown [2]: https://github.com/google/code-prettify