Private Sub 输入数据_Click() Dim ShName As String ShName = Range("B1") On Error Resume Next Debug.Print Sheets(ShName).Name If Err.Number <> 0 Then Err.Clear Sheets.Add ActiveSheet.Name = ShName With Sheets(ShName) Sheets(ShName).Select Sheets(ShName).Move After:=Sheets(3) Columns(2).Name = ShName Sheets("管理").Select End With End If On Error GoTo 0
End Sub 只+了1句,蓝色的,是这样吗 [em09] |