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


ADVERTISEMENT

Move A Number From A Group Automatically And Post In A Different Colume

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

Find If The Cells In Colume B Are In Cloumn A And Do Some Copy Pasting

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

Copy Brand Colume With Word = " Beckhoff " To Sheet1

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







Copyrights 2005-15 www.BigResource.com, All rights reserved