should this code be on different lines

[ammartino44]

Should this code be on different lines? I'm using code from someone and it doesn't make sense to me. It's taking used range from one sheet and copying it, right? Doesn't there need to be a paste in the workbooks? It seems like workbooks should be on a different line. Also, what does the last part do with end (3) (2)?

.Sheets(i).UsedRange.Copy Workbooks("Master workbook.xlsx").Sheets("Master").Range("A" & Rows.Count).End(3)(2)

[Leith Ross]

Hello ammartino44,

The period before Sheets indicates this code line is part of a With ... End Statement. Please show the full code when posting. Guessing is a waste of time.

[skywriter]

The way copy syntax works in VBA is you specify what you want to copy then immediately follow it with where you want to copy it to. If you don't specify where to copy it to, it just goes into the clipboard.

Range("A" & Rows.Count).End(3)(2)

This code goes to the very last cell in column A all the way at the bottom of the sheet and then comes back up until it runs into some data and then goes down one cell. It finds the very last cell with data in it and goes to the cell below it. This is where what you copied is getting pasted.