Hi everyone:

I had posted a similar question a while ago, and I never got an answer that
made sense to me. I am sure the experts did not understand my question.
Basically, I am trying to create a variable of type Range, dump some cells
into this variable, manipulate the contents (format, value, etc) of the
variable without affecting the original cells where the data came from, and
then dump my result in another area of the sheet. This way, I keep the
original data intact, and show the manipulated data as well. I can come up
with some work arounds on this, but I want to use a variable just like
y=x
y=2*y+1
z=y

As you see in this example, y is a dummy variable and whatever I do to it,
it will not affect x. That is exactly what I am trying to achieve, but with
a range. Now, as I mentioned before, I need to manipulate values, formats,
color, character formats, etc.

I am not sure if this is at all possible. If it is, and someone has a code
or explanation on how to do this, I appreciate your help.

Bob