Thank you. I'll go ahead and try out your suggestions right away.

I did notice something that I forgot before. Column A that I a
pasting from has conditional formating, with absolute references t
$A$1. When I paste this column, the conditional formating gets pasted
too.

When I replace...

ActiveSheet.Paste

With...

ActiveSheet.PasteSpecial Paste:=xlFormulas

I get another run-time 1004 error: Application-defined o
object-defined error.

Thanks again

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com