Copy Range with Variable

[Jiptastic]

I'm trying to copy to a range using several variables. This is supposed to copy to the first empty cell in Column A, but depending on the variable REPEAT it may need to copy to several cells below as well.

Please Login or Register  to view this content.

This does not work

[protonLeah]

I don't understand what you are trying to do.

You said: "This is supposed to copy to the first empty cell in Column A..." which means (to me) that you want to start at the top of column A and go down one row past the first empty cell to include it in the copy range, though I don't know why you want to do that. However, the code: Cells(Row, 1).Copy only copies a single cell.

The remainder of the line, starting with "Sheets( ..." is the destination into which to paste the copied data.
So, please explain exactly what you are trying to copy and the destination where it should be pasted.