A co takto:
Dim shPrem As Worksheet
Set shPrem = Sheets(1)
shPrem.Name = "Komponent"
alebo takto:
Dim shPrem As Worksheet
Set shPrem = ActiveSheet
shPrem.Name = "Komponent"
Dufam ze som postacil ja :))
Mifko
> Potrebujem premenovat v exceli sheet na nazov "Komponent".
>
> Z nazvu "List1" to ide takto:
> Sheets("List1").Select
> Sheets("List1").Name = "Komponent"
> Povodny nazov sa ale casto meni.
>
> Da sa sheet premenovat bez zadavania povodneho nazvu?
>
> Ak pouzijem:
> ActiveSheets.Select
> tak to nejde :-( .
This archive was generated by hypermail 2.1.2 : 11. 03. 2002, 12:57 CET