Range object

[Zsola]

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.

 

[Rob van Gelder]

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.

 

[Guest]

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

 

[Bob Phillips]

Set myRange = Range("A1:C10")

--

HTH

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