回複：為什麽我不能 copy （excel vba)？？

應該是paste的目標區選取不正確. 做了如下改動,

Sub test()

Dim i As Integer

Worksheets(1).Activate

For i = 1 To 20

If Int(Cells(i, 1)) = Cells(i, 1).Value Then

Cells(i, 1).EntireRow.Copy
Worksheets(2).Select

Worksheets(2).Rows(i).Select

Worksheets(2).Paste

End If

Next

End Sub

所有跟帖： 

• 謝謝！！ -lovchina- ♀ (0 bytes) () 10/03/2008 postreply 13:27:00