I don't think you can do what you asked, at least not directly. The only way
I can think of for you to do what you want is to copy the source cells to
the destination location and then to either manipulate the location cells
directly or assign them to your range variable and manipulate the cells by
using the range variable you assigned them to. For example, something like
this...

Sub Test()
Dim R As Range
With Range("A1:F9")
.Copy Range("X5")
Set R = Range("X5").Resize(.Rows.Count, .Columns.Count)
End With
' Now, manipulating R will manipulate the only
' the "dump to" range while leaving the original
' range intact.
End Sub

--
Rick (MVP - Excel)


"Bob" wrote in message
...
Hi Rick:

Thanks for your help. Yes, the data will be continuous, and may expand on
more than one column. This is the same problem that we discussed on 9/28,
and 9/30. At this point, I am not so much concerned about dumping the
data, as storing my range in a variable, play with the variable, and not
have the original data changed.

Bob

"Rick Rothstein" wrote in message
...
For the solution I have in mind... will the location you want to dump the
manipulated cells to be contiguous (whether the original cells were
contiguous or not)? For example, if your original cells are A1:C3, F4:F9,
G2:G7, then where to you want them when you dump them elsewhere on the
sheet?

--
Rick (MVP - Excel)


"Bob" wrote in message
...
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