Sub TTT() On Error Resume Next ThisWorkbook.Names("DataBase").Delete On Error GoTo 0 ActiveWorkbook.Names.Add Name:="Database", RefersToR1C1:="=Sheet1!R3C1:R6C2" Range("DataBase").Select End Sub
以下是引用吕?布在2009-11-9 18:00:00的发言: Sub TTT() On Error Resume Next ThisWorkbook.Names("DataBase").Delete On Error GoTo 0 ActiveWorkbook.Names.Add Name:="Database", RefersToR1C1:="=Sheet1!R3C1:R6C2" Range("DataBase").Select End Sub