Another question about variables

[davidam]

Hello Everyone,
Would anyone care to comment on why one must sometimes use
Set vrble = 'Whatever'
and at other times one uses
vrble = 'Whatever'

It seems that if my variable is a String, then I do not use Set , but if it is a Range, then I must use Set. Is this correct?
Thanks!

 

[AlphaFrog]

When the variable is of an Object type (Range, worksheet, commandbutton, chart, etc.) then you have to use the Set keyword.

When the Variable is of a Data type (not an object) like strings, integer, long, etc., then the Let keyword is optional.

 

[davidam]

Great, that explains it.
Thank you!