specifying ranges using cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using cells to specify range 1
loop to copy paste 5
first sip of working with range in vba excel 6
Duplicating worksheet based on range and changing worksheet name 3
Error 1004 3
Run Time Error '1004' 1
Arrays and scattered cell values or another way? 16
Need help with listbox 6

Back
Top