No it's syntax not style. Try it with an object variable.
For example:
Sub StopUsingParentheses()
Dim rngTest As Range
Dim x As Long, y As Long
Set rngTest = Range("A1")
' oops!
macro1 (rngTest)
x = 4
y = 5
' this won't even compile (so commented out)
' macro2 (x, y)
' and this just seems weird:
macro2 (x), (y)
' but you can do:
Call macro1(rngTest)
Call macro2(x, y)
End Sub
Sub macro1(rng As Range)
MsgBox rng.Address
End Sub
Sub macro2(var1, var2)
MsgBox "Var 1 is: " & var1 & "; var2 is: " & var2
End Sub
Bookmarks