想新建工作表，sheet1的a1:a12写了1-12月，写了代码以后，为什么一点反应也没有？

蔚蓝0827

Sub 新建()
Dim sht As Worksheet
Dim i, k As Integer

For Each sht In Sheets
For i = 2 To Sheets.Count
     k = 0
    If sht.Name = Sheet1.Range("a1:a" & Range("a65536").End(xlUp).Row) Then
    k = 1
    End If
    If k = 0 Then
    Sheets.Add after:=Sheets(Sheets.Count)
    Sheets(Sheets.Count).Name = Sheet1.Range("a1:a" & Range("a65536").End(xlUp).Row)

    End If
Next

Next

End Sub

海好呀

Sub 新建()
Dim sht As Worksheet
Dim i, k As Integer
Application.ScreenUpdating = False
Set sht = ActiveSheet
With sht
    k = sht.Cells(sht.Rows.Count, 1).End(xlUp).Row
    For i = 1 To k
        Sheets.Add after:=Sheets(Sheets.Count)
        Sheets(Sheets.Count).Name = .Cells(i, 1)
    Next i
End With
Application.ScreenUpdating = True
End Sub

excel玉米

当然要循环建表才行。你的做法有误。
Sub 新建()
Dim sht As Worksheet
Dim i, k As Integer,Arr()
For i = 1 To Sheet1.Range("a1:a" & sheet1.Range("a65536").End(xlUp).Row)
       For Each sht In Sheets
              If sheet1.cells(i,1).value＜＞sht.name then
         k = k+1
       Redim preserve arr(1 to k)
Arr(k)=sheet1.cells(i,1).value. '提取还没有建的月你表名称到数组
  End If
   Next sht
Next i
For i=1 to ubound(arr)
        Sheets.Add after:=Sheets(Sheets.Count)
  Sheets(Sheets.Count).Name = arr(i)
Next i
End Sub

excel玉米

fzxba

1. Sub newWks()
   
2.   Dim ar, i As Integer, wks As Worksheet
   
3.   ar = Sheet1.Range("A1").Resize(12).Value
   
4.   On Error Resume Next       '利用错误
   
5.   For i = 1 To UBound(ar)
   
6.     Set wks = Worksheets(CStr(ar(i, 1)))
   
7.     If Err.Number <> 0 Then  '不存在工作表时，会出错 Err.Number <> 0
   
8.       Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = ar(i, 1)
   
9.       Err.Clear              '清除
   
10.     End If
    
11.   Next
    
12.   Set wks = Nothing
    
13. End Sub

复制代码