见附件- Sub paixu()
- With Sheets(1)
- .Range("a3", .Range("a3").End(xlToRight).End(xlDown)).Sort .Range("b3"), xlAscending, , , , , , xlNo
- End With
- With Sheets(2)
- .Range("a3", .Range("a3").End(xlToRight).End(xlDown)).Sort .Range("d3"), xlAscending, , , , , , xlNo
- End With
- With Sheets(3)
- .Range("a3", .Range("a3").End(xlToRight).End(xlDown)).Sort .Range("g3"), xlAscending, , , , , , xlNo
- End With
- End Sub
复制代码 |