#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,092
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"