Hi, I need to some code to enable all cells on sheet 1 of workbook A to be
copied into sheet 2 of workbook B.

I have done this before but for some reason I get an error message sayig
subscript out of range when I run the code.


It would also be really goo if I could incorporate code to open workbook A
from workbook B to minimise the user input even furtehr. A message bo asking
for the file name would be needed.