View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HROBERTSON HROBERTSON is offline
external usenet poster
 
Posts: 11
Default 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!