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.

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.

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.


.

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.


.