I see you already got a working solution from Scott, I didn't look back at your
original question where it appears that your are referring to
workbooks as if they are worksheets.