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

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

The set command is used to assign a value to an object of some type,
document, PivotTable, Workbook, Worksheet, ToolBar and Range are just a few
of the object one can assign to an object variable.

Failure to assign an object variable a value without the use of SET will
produce an error.

I would suggest that at the top of the module you enter Option Explicit on a
line by itself to insure that all variables must be declared before assigning
them a value of some type.


--
Kevin Backmann


"peyman" wrote:

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

On Oct 22, 12:35 pm, peyman wrote:
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

The second statement uses the default property of Range, which is
Value.

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

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

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