Reference without writting to hdd

Originally Posted by JosephP

no-it will work in any workbook as long as the Book1 file is open in the same instance of Excel.

Subscript out of Range.