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?