Anyone can help me?
I try to cut row in a sheet and paste to another sheet by VBA
but can not work
-----------------
Sub Testcut()
Dim Line As Integer
I = Worksheets("Sheets1").Range("CheckIndex")
Worksheets("Sheets2").Rows("I").Select
Selection.Cut
Line = [ADDFGLINE] + 1
Worksheets("Sheets3").Rows(Line).Paste
End Sub
-----------
I try to cut row in a sheet and paste to another sheet by VBA
but can not work
-----------------
Sub Testcut()
Dim Line As Integer
I = Worksheets("Sheets1").Range("CheckIndex")
Worksheets("Sheets2").Rows("I").Select
Selection.Cut
Line = [ADDFGLINE] + 1
Worksheets("Sheets3").Rows(Line).Paste
End Sub
-----------