delete content

  1. S

    Delete content of Word chapters but keep the title - VBA

    Hello, I hope all of you are healthy. I have a word document that contains several chapters including assessments concerning various topics. Since I have to update the document each week, I have tried to write a macro that deletes the contents of all chapters, but keeps the title of the...
  2. E

    Help with building macro to create new rows and copy and paste cell content into new rows

    Hello, I have been manually doing a process all day long and I want a macro that allows me to highlight a row and do the actions automatically. Can someone on the board take a look at this and help me make a macro? The column looks like this originally: <tbody> Serial Date Title Name A Name B...
  3. D

    Possible Loop Solution Needed: Delete Row Based On Conditions

    Objective: To have no more of 10 specialties per name. The 10 specialties must be the same each time I run it even if there is an introduction of a new specialty next time I run it. Whatever is greater than 10 specialties with the same name should have it's entire row deleted. Problem: I have...
  4. A

    Delete cell content in entire workbook if background color is yellow

    I am looking for a vba code that would delete the content of a cell based on its background color. My workbook has several worksheets in which cells have a light yellow background if the user can input in them. Now I created a button which would reset the entire model, ie delete the content...

Watch MrExcel Video

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