Habe mir ein script geschrieben das mir die Namen vergibt also einträgt.
Aber aus irgendeinem Grund klappt das nicht so richtig.es stehen nur immer in einem sheet Namen für spalten und nicht in alle.Mein Gedanke war, gibt es vieleicht eine Anzahlsbeschränkung für Namen oder was mache ich falsch ?
Vielen dank für nen Tipp besten grüße Christian !
Sub neu()
For x = 3 To 18
Worksheets("Invest 2006").Select
namee = Worksheets("Invest 2006").Cells(3, x)
namee = WorksheetFunction.Substitute(namee, "/", "_")
namee = WorksheetFunction.Substitute(namee, " ", "_")
namee = WorksheetFunction.Substitute(namee, ".", "_")
namee = WorksheetFunction.Substitute(namee, "-", "_")
ActiveWorkbook.Names.Add Name:=namee, RefersToR1C1:=ActiveSheet.Columns(x)
Next
For x = 3 To 18
Worksheets("Invest 2007").Select
namee = Worksheets("Invest 2007").Cells(3, x)
namee = WorksheetFunction.Substitute(namee, "/", "_")
namee = WorksheetFunction.Substitute(namee, " ", "_")
namee = WorksheetFunction.Substitute(namee, ".", "_")
namee = WorksheetFunction.Substitute(namee, "-", "_")
ActiveWorkbook.Names.Add Name:=namee, RefersToR1C1:=ActiveSheet.Columns(x)
Next
For x = 3 To 18
Worksheets("Invest 2008").Select
namee = Worksheets("Invest 2008").Cells(3, x)
namee = WorksheetFunction.Substitute(namee, "/", "_")
namee = WorksheetFunction.Substitute(namee, " ", "_")
namee = WorksheetFunction.Substitute(namee, ".", "_")
namee = WorksheetFunction.Substitute(namee, "-", "_")
ActiveWorkbook.Names.Add Name:=namee, RefersToR1C1:=ActiveSheet.Columns(x)
Next
For x = 3 To 18
Worksheets("Invest 2009").Select
namee = Worksheets("Invest 2009").Cells(3, x)
namee = WorksheetFunction.Substitute(namee, "/", "_")
namee = WorksheetFunction.Substitute(namee, " ", "_")
namee = WorksheetFunction.Substitute(namee, ".", "_")
namee = WorksheetFunction.Substitute(namee, "-", "_")
ActiveWorkbook.Names.Add Name:=namee, RefersToR1C1:=ActiveSheet.Columns(x)
Next
End Sub