View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Axel Axel is offline
external usenet poster
 
Posts: 40
Default The differents of the sheets name and caption.



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 ***