Collection - add

[pit84]

Hi

two versions, one works, second one gives: Compile Error, Expected: =

1) CollectionName.Add cell.Value, CStr(cell.Value)
2) CollectionName.Add(cell.Value, CStr(cell.Value))

What is the difference? Why the second one generates an error

Thanks

 

[Scott Huish]

Because when you put parameters in parentheses, VBA typically expects that it will be assigned to a variable or object.

 

[RoryA]

Or if you use Call.