谢谢各位大大了.作者: pureshadow 时间: 2010-8-29 19:42
dim MyS as long
for MyS = 1 to sheets.count
if sheets(MyS).name = "test" then
sheets(MyS).name = "testOK"
end if
next作者: liyh67 时间: 2010-8-29 19:45
Sub test()
Dim sh As Worksheet
On Error GoTo er
Set sh = Sheets("test")
sh.Name = "testOK"
Exit Sub
er:
Sheets.Add
ActiveSheet.Name = "test"
End Sub