Hi Harlan

I am having some problem using your code. Your resonses above were very
helpful. Thanks for posting it by the way.

I am trying to 'pull' a range, say {1,2,3}. When the target workbook is open
I can retrieve the entire range. However, when the target workbook is closed
I can only retrieve the first element in the range, 1 in this example.

Thanks in advance.
Pat