VBA - Set

[ajocius]

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

 

[Bob Phillips]

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)

 

[Mike Fogleman]

Read the VBA help on "Set".

Mike F