macro delete rows

  1. S

    VBA to delete rows with certain value before duplicating

    Hi guys, I have this VBA code: Public Sub ShippingForecastMoveAlong() Dim newName As String On Error Resume Next newName = InputBox("Please Enter New Period") If newName <> "" Then ActiveSheet.Copy After:=Worksheets(Sheets.Count) On Error Resume Next...
  2. K

    Command button delete rows... sort of

    Hi, I found a peace of code written bij Joe Was in: https://www.mrexcel.com/forum/excel-questions/9165-entire-row-delete.html I modified it to work on a command button. But it removes every other row :confused: Lets say row 11 till 18 are empty/< 1 then it removes 11, 13, 15, 17. I've...
  3. M

    Macro to delete rows below a certain value

    Hi, I have a large set of data and need to run a macro that sorts "column CN", then removes the data where the value in column CN is <50,000. I can do the sorting but not the deleting: please could you help? The macro so far with the sorting .... Sub Macrox() ' ' Macrox Macro ' ' Keyboard...
  4. S

    Macro to filter based on lists

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
    • shoddy
    • Thread
    • macro delete rows macro filter macro using list
    • Replies: 0
    • Forum: Excel Questions

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