Never mind, I got this worked out. Again thanks for the help.

gjameson wrote:
My sheet name is CALLS in both workbooks.

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,
[quoted text clipped - 5 lines]

End Sub

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