Hello everyone!

Problem:– runtime error 9, “subscript out of range” - everywhere!

Given: Workbooks MEgdF.xls and MEgdB.xls.
Task: Transfer input data and estimated data from MEgdF.xls to MEgdB.xls.

Workbook MEgdF.xls
Worksheet “Data&Parms”, Column H: Input data in cells 1 to 21
Worksheet “Output”, Column F: estimated data in cells 1 to 41.

Workbook MEgdB.xls
Worksheet “Data&Parms”, Column H: Estimated data from MegdF.xls read into cells 1 to 41
Worksheet “Output”, Column F: Input data from MegdF.xls read into cells 1 to 41.

I am using Excel 2007 and I know nothing of Excel VBA whatsoever.

Macros tried available upon request.

Can anyone help?

Best regards,

“MyCousinVinnie