View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FrigidDigit FrigidDigit is offline
external usenet poster
 
Posts: 21
Default Autocopy between 2 workbooks

Hi all,

I would like to create code to accomplish the following but as I know very
little any help would be appreciated:

I have 2 workbooks of which the names could differ from time to time
I would like to create a procedure to copy say range A1:H13 from workbook 1
to the same range in workbook 2.
Which commands would I use to switch between the 2 workbooks and how will I
identify them so that I paste to the correct 1?

TIA

FD