Referencing rows within a loop

[brandonlyz]

Hi all,

My issue comes about when I'm trying to copy data from certain rows within a sheet, where the location of the rows is directly related to the value during the particular loop process. However, this gives me a Method'Range of object'_Worksheet' failed error.

If you're confused, here's an example of my code:

For pnumber = 0 To 16
r_copy = 2 + 17 * pnumber
c_copy = 18 + 17 * pnumber
Sheet3.Range("2:18") = Sheet2.Range("r_copy:c_copy")

Do ask if you any other questions, and I will be more than glad to answer them. Thanks for reading.

Ps: This is being run by a userform.

 

[Dendro]

Hi,

The problem is situated here:

Sheet3.Range("2:18") = Sheet2.Range("r_copy:c_copy")</pre>

You can only enter cells in the form like A1 in range like that.
You could however.

Sheet3.Cells(2,18) = Sheet2.Cells(r_copy,c_copy)

</pre>