Sub Declaration

[Haikal_]

Hi

I hope someone can answer my general query.

Sometimes i find the routine Sub is written as

Please Login or Register  to view this content.

What is the difference between this and:

Please Login or Register  to view this content.

Thanks!

[GC Excel]

Hi,
In the first version, you need to declare, set and then pass values to the sub to make in work, something like:

Please Login or Register  to view this content.

While in the second version, you declare and set your variable in the sub directly.