copy the third worksheet before the 2nd worksheet : Worksheet Move « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Worksheet Move

copy the third worksheet before the 2nd worksheet

 
Sub SimpleWorksheetMovement() 
    ' copy the third worksheet before the 2nd worksheet 
    ThisWorkbook.Worksheets(3).Copy ThisWorkbook.Worksheets(2) 
End Sub








Related examples in the same category

1.Move sheet to the end
2.Drag the third worksheet to the first sheet position
3.copy the third worksheet to a new book