請問一下我用VBA 複製A檔案到B檔案
本來要將H欄到S欄 全部是空白就刪除 , 但怎麼判斷都無法寫出來
後來嘗試用假設H欄加總到S欄 等於0 就刪除 , 沒想到出現這個問題(圖片)
已事先將儲存格轉為數值 為什麼還會出現這個問題呢?
如果要判斷空白就刪除要怎麼表示呢???
如下問題
程式碼- Dim RepSht As Worksheet
- Set RepSht = Sheets("CCC")
- With RepSht
- For u = .Range("A65536").End(xlUp).Row To 2 Step -1
- If .Cells(u, "I") = "" And .Cells(u, "J") = "" And .Cells(u, "K") = "" And .Cells(u, "L") = "" And .Cells(u, "M") And .Cells(u, "N") = "" And .Cells(u, "P") = "" And .Cells(u, "Q") = "" _
- And .Cells(u, "R") = "" And .Cells(u, "S") = "" Then
- .Rows(u).Delete
- End If
- Next
- End With
 TEST.rar (15.05 KB)
|
發表於 2016-4-15 01:59
| 
