Range object
 

Dear Developers,

how can I make a copy of an range object(eg. range
("a1:c10") ), that I can manipulate(eg. change values or
format of a column of this range) instead of the original,
so this manipulation will not affect the original one's
values or format.

Range object
 

You could copy the worksheet or copy the range to a new range.

In either case, start the macro recorder to capture the code for what you're
after.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Zsola" wrote in message
...
Dear Developers,

how can I make a copy of an range object(eg. range
("a1:c10") ), that I can manipulate(eg. change values or
format of a column of this range) instead of the original,
so this manipulation will not affect the original one's
values or format.

Range object
 

What I want to do is a usable range-variable refering to
an exact copy of a given range.



-----Original Message-----
You could copy the worksheet or copy the range to a new
range.

In either case, start the macro recorder to capture the
code for what you're
after.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Zsola" wrote in message
...
Dear Developers,

how can I make a copy of an range object(eg. range
("a1:c10") ), that I can manipulate(eg. change values or
format of a column of this range) instead of the
original,
so this manipulation will not affect the original one's
values or format.


.

Range object
 

Set myRange = Range("A1:C10")

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
...
What I want to do is a usable range-variable refering to
an exact copy of a given range.



-----Original Message-----
You could copy the worksheet or copy the range to a new
range.

In either case, start the macro recorder to capture the
code for what you're
after.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Zsola" wrote in message
...
Dear Developers,

how can I make a copy of an range object(eg. range
("a1:c10") ), that I can manipulate(eg. change values or
format of a column of this range) instead of the
original,
so this manipulation will not affect the original one's
values or format.


.