- 当前sheet确认
- 把sheet1移动到sheet3前边
Sub Hello()
'10
Worksheets("Sheet1").Move Before:=Worksheets("Sheet3")
End Sub
3. 把sheet2移动到sheet1后边
Sub Hello()
'11
Worksheets("Sheet2").Move after:=Worksheets("Sheet1")
End Sub
Sub Hello()
'10
Worksheets("Sheet1").Move Before:=Worksheets("Sheet3")
End Sub
3. 把sheet2移动到sheet1后边
Sub Hello()
'11
Worksheets("Sheet2").Move after:=Worksheets("Sheet1")
End Sub