macro to delete

  1. pedie

    Need a macro to delete 4 rows after a value..please help!

    I have data from A1:D512 In A col i have ID.... followed by numbers (eg; ID65498711, ID65498715 etc) between every id there is a gap of like 15 - 20 row etc. please see table below. I want the macro to delete 4 next whole row; eg if A1 has ID6542122; I want the macro to delete row A2, A3, A4...
  2. pedie

    Macro help please

    Macro help please In a sheet1, range A1 to D1000 has datas...including customers account number. I want the macro to replace all the account number with dats. I want all the numbers no matter what kinda number it is from 1-10 replace it with dots... Please design a macro... Thanks again!

Watch MrExcel Video

Learn Excel - "Hide Blank Rows Without a Macro" - Podcast #1736

This Week's Hot Topics

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
Top