第1个回答 2010-07-16
在左侧工程管理器窗口中双击你需要运行的工作表名称sheet1(..),在代码窗口中上方下拉列表中选择:通用选为:worksheet;右侧改为change
粘贴以下代码:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Column < 3 Then
Range("A2").Select
Range("A1:B65536").Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess
Columns("A:B").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Key2:=Range("B1") _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, SortMethod:=xlPinYin, DataOption1:= _
xlSortNormal, DataOption2:=xlSortNormal
End If
End Sub