Macro - Varying Range to Copy
 

I need to write a macro to go out to another spreadsheet copy a set of rows,
and paste them into the original spreadsheet. The range to copy will always
start at the same cell, but may vary in length (i.e. a1:g12, and then the
next time a1:g50). Is there a way to do this? Any help would be greatly
appreciate.

Thank You in advance!

Macro - Varying Range to Copy
 

iEnd = Sheets("Sheet1").Range("A1").End(xlDown).Row
Sheets("Sheet1").Range("A1:G" & iEnd).Copy

Hth,
Merjet