在excel中Range("A4").CurrentRegion.Sort Key1:=Range("A4"), Or...答:=xlAscending,Key2:=单元格区域(_"B4"),Order2:=xlAscending,Key3:=单元格区域("C4"),Order3:=xlAscending,_标题:=xlGuess,OrderCustom:=1,区分大小写:=False,方向:=_xlTopToBottom,排序模式:=xlPinYin,DataOption1:=xlSortTextAsNumbers,_DataOption2:=xlSortNormal,DataOption3:=普通排序 ...
vb中,;:都有什么作用?答:分号还可以在显示参数赋值时用,如:Selection.Sort Key1:=Range("A1"), Order1:=xlDescending, Key2:=Range("B1") _, Order2:=xlAscending, Key3:=Range("D1"), Order3:=xlAscending, Header:= _xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _SortMethod:=...