How To Detele Col Hv One Zero On Colume C
Dec 1, 2007
how to modify the below code.
right now it will check for col C and D , if both col have zero it will delete, i like to change the code , so it only check for C col , if it is zero , it delete the row.
Sub macro_07_if_detect_2_zero_delete_row()
Dim lastrow As Long, i As Long
Application.ScreenUpdating = False
Application.Calculation = xlManual
With ActiveSheet
On Error Resume Next
.Columns(3).SpecialCells(xlCellTypeFormulas, xlErrors).EntireRow.Delete
On Error GoTo 0
lastrow = .Cells(Rows.Count, 3).End(xlUp).Row
For i = lastrow To 1 Step -1
If .Range("C" & i).Value = 0 And .Range("D" & i).Value = 0 Then .Rows(i).Delete
Next i
End With
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic
End Sub
View 9 Replies
Nov 3, 2008
I would like to move a number from a group, automatically and post in a different colume. Like remove the 4 from 439 to a different colume.
View 14 Replies
View Related
Mar 10, 2008
I got 2 columns A and B, I need to find if the cells in colume B are in cloumn A and do some copy pasting. But sometimes when it cant be find in column A, then VBA shows an error message. What I want is if it cant be find in column A, then skip it and go to the next cell of B and find it in A again. I think it can be done with On error resume next, On error goto 0, but i cant make it work.
View 2 Replies
View Related
Mar 1, 2008
I like to copy all description with Brand BECKHOFF to sheet1.
and Banner to sheet2.
i have many brand , and i like it copy to individual sheet.
now i have to do it manually , it take very long and not productive.
INVC X201BANNER 202BAUMER 203BECKHOFF204BECKHOFF205BECKHOFF Excel tables to the web >> Excel Jeanie HTML 4
Brand name
Banner
Baumer
Beckhoff
Copy all row to :-
sheet 1
sheet 2
sheet 3
and rename
sheet 1 to Banner
sheet 2 to Baumer
Sheet 3 to Beckhoff
View 9 Replies
View Related