set in vba?

[dani1]

hi ppl,

actually i wanted to know wat does "SET" do in vba?can anyone explain this with example?

 

[Richard Schollar]

Hi

You use Set when you want to assign an object reference to a variable eg:

Dim rng As Range
 
Set rng = Range("A1:A100")  'object reference

You use Let (or omit it altogether) when assigning a simple scalar value to a variable eg:

Dim lng As Long
 
Let lng = 100
 
'equiavlent to:
 
lng = 100