deleterow

  1. B

    VBA errors while trying to delete rows based on column value

    Hi, I am trying to delete rows that have a zero value in column E. I have tried various methods and keep getting 'object does not support this property or method' or 'type mismatch errors. Currently I have: For deleterow = .Range("E" & Rows.Count).End(xlUp).Row To 1 Step -1 If .Range("E" &...
  2. M

    oh no!! Another delete row based on cell value question!!

    SO I have a macro that i am using to create a specific report for my users to show them the values that are being used to calculate a value based on their input to the workbook. The macro first checks to see if the worksheet laborreport is present and if so deleted the current version of that...
  3. S

    Delete ntire row if cell = Yes

    I want to delete any row in the "Delivered" sheet that has "Yes" in a cell in Column "G:G" For Each cell In Sheets("Delivered").Range("G:G") If cell.Value = "Yes" Then deleteRow = cell.Row End If
  4. V

    Macro to Delete blank rows

    I found in an old thread here a macro deleting blank rows in an excel sheet, changing "pseudo blanks" into real blanks first. It was this little script: Sub RemoveEmptyRows() On Error Resume Next With Range("B300:B1000") .Value = .Value...
  5. M

    Select Case - Loop - Delete Row

    OK, so I have the following code: Dim oneCell As Range Dim HeaderRange As String Range("Z1").Select Range(Selection, Selection.End(xlDown)).Select HeaderRange = Selection.Address For Each oneCell In Range(HeaderRange) If oneCell.Value = "" Then GoTo skip End If...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top