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