justaguyfromk

What does the formula look like?
Charles

"justaguyfromky" wrote in message
...
I have a macro that I want to be able to copy and paste from and to
different
cells depending on other criteria. I have a cell with a concatenate
formula
that puts the actual cells that I want to copy from and to.

My question is...
How do I get the macro to read the cell that has the range I want to copy
from and paste into to put the value of the cell as the range in the
macro?