-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
delete content
-
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...- Sarahmueller
- Thread
- Replies: 3
- Forum: General Discussion & Other Applications
-
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...- EPTowers
- Thread
- Replies: 3
- Forum: Excel Questions
-
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...- drmingle
- Thread
- Replies: 0
- Forum: Excel Questions
-
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...- Ankethaton2
- Thread
- Replies: 5
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Copy dates from one sheet to another in range if date is old than 11 months
- Started by DanSMT
- Replies: 35
I am having an issue pulling dates from one workbook.sheet to another workbook.sheet. I've been working through the code. not sure if this is... -
Date and reference number being inserted into footer after the first page
- Started by dpaton05
- Replies: 36
How do I put things into the footer on all pages after the first using vba? -
Highlight Adjacent Cells in a grid
- Started by JLEMS
- Replies: 33
Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get... -
Calculating lost hours per week
- Started by gd6noob
- Replies: 26
Hi there, I have a worksheet that calculates lost hours for employees. Basically it cells AE to CD are weeks 1 to 52 and it looks at the start... -
VBA Open .txt file with a string
- Started by ItalianPlatinum
- Replies: 25
I have a VBA code that works like a charm that displays a dialog box and allows a user to select a file. I am trying to enhance it to force the... -
Invalid qualifier
- Started by dpaton05
- Replies: 24
I have a procedure that moves some buttons. They need to be moved to just below the bottom of the last entry in column A. I get an error saying...