specifying ranges using cells
I need to copy a range of cells and paste the values into another worksheet
within a loop where the column part of the cell reference changes with each
loop iteration. For example, copy & paste the values from Worksheet One
cells B5 through B10 to Worksheet Two beginning at cell D7; then shift to C5
through C10 to cell E7, and etc. I have used both Range and Cells approaches
without success. Is there an easy way to do this?
|