[課業] VBA程式碼
這是整理用的vba程式碼,可用於刪除#N/A值那一欄
Sub Macro1()
Dim i As Integer, j As Integer
For i = 2 To 3561
For j = 2 To 14
If IsError(Cells(i, j)) Then
Cells(i, j).Select
Cells(i, 1).EntireRow.Delete
i = i - 1
End If
Next j
Next i
End Sub
By 羅哥好帥
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.117.188.186
推
10/12 17:35, , 1F
10/12 17:35, 1F
推
10/12 23:02, , 2F
10/12 23:02, 2F
→
10/13 23:33, , 3F
10/13 23:33, 3F