I’d like to make an assertion. If you have an open parenthesis preceded by a space, you should remove the parentheses. Here’s an example:
Dim myCollection As Collection
Dim myObject As Object
When you put parentheses around an object, VBA evaluates that object and, absent a property, returns the default property. The first Add might error or might not work as expected. Here’s another example:
Dim dValue As Double
dValue = 1.1
In this case the parentheses don’t do any harm, but they’re still unnecessary. And finally:
Dim lValue As Long
lValue = CLng(1.1)
In this case there is no space before the open parenthesis, so it’s not just preferred, but necessary.
Can you think of a case where an open parenthesis preceded by a space is required or preferred?