Hi Tom,

As I have a timeformat that is controlled from a VBA-code in the mai
sheet, and that code will be missing in the new sheet I get the wron
format and only zeros.

Thanks for all your help, I really apprecciate it, but I´ll have t
think of another solution.

//Thomas

P.S

I have found it!

If I choose Archive-Printarea and select my wanted area, then I get al
values on the same sheet!!

Many thanks!!

//Thoma

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