Set Keyword

[mark1]

When is it appropriate to use the Set keyword in VBA?

a = Range("A1:A36")

Set a=Range("A1:A36")

Thanks!!!

 

[Frank Kabel]

Hi
if you want to assign an object to a variable.