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.