| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
question on VB code
appreciate it.
"Bob Phillips" wrote: All of them, myRange.Interior.Colorindex = 37 myRange.Font.Name = "Verdana" etc. Look up Range in VBA help and click on the Properties link to see them -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "peyman" wrote in message ... hi Bob, could you please let me know what other range properties besides the value can be allocated to myRange in case I use the "set"? "Bob Phillips" wrote: Assuming that you have not declared the variables, and so they assume variant type, then - the first creates a range object variable pointing at the range in question. Through this variable, you can access any the range properties, including the values - the second just loads the values in the range into an array variable, so only giving access to those values. They do different things, so using one in place of the other will probably not do what is required. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "peyman" wrote in message ... hi, can anybody explain what the difference is between these two expressions: set myRange=activesheet.range("A10:B20") myRange=activesheet.range("A10:B20") and what will happen if we use the codes in place of each other? thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another code question | Excel Discussion (Misc queries) | |||
| VB Code Question | Excel Discussion (Misc queries) | |||
| VB Code Question | Excel Discussion (Misc queries) | |||
| VBA code question | Excel Discussion (Misc queries) | |||
| Easy VB code question | Excel Discussion (Misc queries) | |||
Threaded Mode
