Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
specifying ranges using cells
For i = 2 to 3 Cells(5,i).Resize(,6).Copy Worksheets("Sheet2").Cells(7,i+2) Next i -- HTH RP (remove nothere from the email address if mailing direct) "Mitch" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Cells (Ranges) | Excel Discussion (Misc queries) | |||
ADD DIFFERENT RANGES OF CELLS | Excel Discussion (Misc queries) | |||
Dynamic Ranges/Cells?? | Excel Programming | |||
empty cells in ranges | Excel Discussion (Misc queries) | |||
Special Ranges of Cells | Excel Programming |