set in vba?

dani1

Board Regular
Joined
Mar 23, 2010
Messages
90
hi ppl,

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

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

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

Code:
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:

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

Watch MrExcel Video

Forum statistics

Threads
1,109,087
Messages
5,526,767
Members
409,720
Latest member
Antwain

This Week's Hot Topics

Top