Or leave the codename Ark1 and use:

Sheet2.Name = Ark1.range("N14").Value



Axel wrote:

Hi!
I found the solution.
It was just to rename codename from Ark1 to Sheet1.
I have to shorten the distance between my breakes.

Sorry for trouble you with nothing.
Aksel

*** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson