VBA - Set
 

Group,
Again as always thank you for the quick replys and very creativ
answers to my questions. I have a very basic one that I though
someone could give me the details on. I often see examples of "Set".
I'm not sure what this is. How can I use it to better my programmin
experience.

Ton

--
ajociu
-----------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...fo&userid=1769
View this thread: http://www.excelforum.com/showthread.php?threadid=39362

VBA - Set
 

Set is used when assigning to an object variable, like

Set rng = Range("A1")
Set sh = Worksheets("Sheet1"

as against assigning a value to a data variable, like

myNum = 17
myString = "me"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ajocius" wrote in
message ...

Group,
Again as always thank you for the quick replys and very creative
answers to my questions. I have a very basic one that I thought
someone could give me the details on. I often see examples of "Set".
I'm not sure what this is. How can I use it to better my programming
experience.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=393623

VBA - Set
 

Read the VBA help on "Set".

Mike F
"ajocius" wrote in
message ...

Group,
Again as always thank you for the quick replys and very creative
answers to my questions. I have a very basic one that I thought
someone could give me the details on. I often see examples of "Set".
I'm not sure what this is. How can I use it to better my programming
experience.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=393623