Thread: VBA - Set
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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