The only time that I have experienced the out of memory error is whe
the record I am tring to copy and paste has a field that has a larg
amount of data. For me it is usually a description field that has
vey long email thread.

Take a look at the record the macro is erroring out on. You may fin
that on of the fields has a large amount of data. I'm not sure on ho
to correct this issue.

Good luck

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