But how do you use that designator in a certain workbook? i.e
"Workbooks(1).Sheet1" doesn't work. Nor doe
"Workbooks.Sheest(Sheet1)" or "Workbooks.Sheets.Sheet1"

Thanks in advance for clearing this up. - Piku

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