My sheet name is CALLS in both workbooks.

gjameson wrote:
One more question. Is there anyway to paste only the data from the worksheet?
The worksheet I am copying from contains a formula and I only want that data,
right now it shows up as an error because of the ref.

You didn't specify which sheets in the workbook you are using so
chose the first tab in each workbook.
[quoted text clipped - 27 lines]

End Sub

--
Message posted via http://www.officekb.com