Thanks again for answer.
I did not use the codename with ("Ark1"), because now I am using a
norwegian version, and there is the codename of the sheets: Ark1, Ark2
etc. And I don't now if excel rename to sheet1, when open in a english
version.
That is why I mix the two types.
'This wont work. And I have tryed different practices with no luck.
Sheet2.range("C2") = Worksheets("Ark1").range _
("I14").Value
'This works fine
Sheet2.Name = Worksheets("Ark1").range("N14").Value
Aksel
*** Sent via Developersdex
http://www.developersdex.com ***