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!
|