Why don't you just call that specific sheet:

Worksheets("By INVOICE").cells(1,1).Value = "COmpany XXX Inc. Page 2"

If the worksheets are all in the same workbook you don't even have t
define them. You can just call them like above.

Hope this helps

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