Thanks Joergen!

However I get an error on this line:

FOR EACH CELL IN .CELLS.SPECIALCELLS _
(XLCELLTYPEFORMULAS, 23

Also I've noticed that it pasted the info in the exact same order a
sheet1
but added the numbers 1 through 13 at the top
(I have 13 number columns)

Thanks,
EMo

--
EMo
-----------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...fo&userid=2318
View this thread: http://www.excelforum.com/showthread.php?threadid=55081