Hello Charlie,

Error 9 is "Subcript out of Range". Something I did notice in your code
which might be a typo is a mssing "(" after Range.

Posted...

With Workbooks("Workbook_Name").Sheets("Sheet_Name").Ra
nge"Named_Range")

Should be...

With Workbooks("Workbook_Name").Sheets("Sheet_Name").Ra
nge("Named_Range")

That would flag a different error if your code were typed this way. If
the Sheet isn't active when the code is run, you will get error 9. Also
check that your variables contain valid data.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=496442