I have a macro which runs while a number of workbooks are open. I kee
getting a Run Time Error 424 when I do the following:

Workbooks(workbook1.xls).Worksheets("Data").Range( "PasteCell").Value
Workbooks(workbook2.xls).Worksheets("Supply").Rang e("CopyCell").Value

I know that both worksheets are open and that the sheet names ar
correct as well as the named ranges. What am I doing wrong?

Thank

--
Message posted from http://www.ExcelForum.com