Hi EMoe

I do not know what is wrong, sorry.
I am using Excel 2003 UK, and you are using?

You can either delete mentioned or you can start each line with an
apostrophe.
This "paragraphe" was to avoid problemes with formulas.
Do you have formulas in sheet 1?

' '// Formula 2 Fixec value
' For Each cell In .Cells.SpecialCells _
' (xlCellTypeFormulas, 23)
'
' cell.Value = cell.Value
' Next cell

Also I've noticed that it pasted the info in the exact same order as
sheet1
Yes, but later in the macro it will be sorted.

but added the numbers 1 through 13 at the top
(I have 13 number columns)
If you step through the macro you will notice that 1 to 13 = 13 to 1 and
later the row will be deleted.

--
Best Regards
Joergen Bondesen


"EMoe" wrote in message
...

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 as
sheet1
but added the numbers 1 through 13 at the top
(I have 13 number columns)

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=550815