시트 이름을 참조하는 방법(이름을 모릅니다) 셀 참조에서 이름이 나옵니다.

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를 워크시트로, shNam을 String으로 shNam = ActiveSheet.range("A1").Value

    Sheets(shNam).Activate