Forum Discussion
VBA for not deleting entire row but just clear-contents and copying records below it one row up
Dim i As Long For i = Cells(Rows.Count, "G").End(xlUp).Row To 2 Step -1 If Cells(i, "G") = 0 Then Rows(i).Delete Next i The above short code I found in the net was a powerful tool in deleting row...
sorry for posting this message, Mr. Man Fai Chan had already posted his solution to this problem.
I only used the hi-lighting of incomplete record. I completely missed the delete program.
so sorry..
many thanks