Wie referenziere ich ein Blatt (dessen Namen ich nicht kenne), dessen Name aus einer Zellreferenz stammt?

Question

Sub New_Code

Dim exists as Boolean

For a = 1 To Worksheets.Count
    If Worksheets(a).Name = ThisWorkbook.Worksheets("Current").Range("V2") Then
        exists = True
    End If
Next a

If Not exists Then
    Worksheets.Add.Name = ThisWorkbook.Worksheets("Current").Range("V2")
End If
wk1.Sheets("Ab").Activate               wk1.Sheets("Ab").Range("A1:CK70").SpecialCells(xlCellTypeVisible).Copy            ThisWorkbook.Worksheets(ThisWorkbook.Worksheets("Current").Range("V2").Value).Activate                ThisWorkbook.Worksheets(ThisWorkbook.Worksheets("Current").Range("V2")).Range("A2").PasteSpecial xlPasteValuesAndNumberFormats

Answer 1

Dim sh als Arbeitsblatt, shNam als String shNam = ActiveSheet.range("A1").Wert

    Sheets(shNam).Activate