How would I make a macro in Excel to delete all text in a range?

Answer First of all, you have two questions, though similar, they would have different answers. Let us say that you wish to do what your last sentence states.The following is the VBA code you would need ... Read More »

Top Q&A For: How would I make a macro in Excel to delete all...

Can you make me an Excel Conditional Row Delete Macro?

When you say "rows that have a 'V' in them", are you saying that is all that is found within the cell, or that the letter "V" might be just one of the characters in that cell for column M. It make... Read More »

How do I delete the range name in Excel 2007?

Open the Excel worksheet containing the range name you want to delete. Go to the "Formulas" tab and click "Name Manager" in the "Defined Name" group. Click on the name you want to delete to select ... Read More »

How do I calculate the most frequent text in a range in MS Excel?

Count How Often a Non-numeric Value OccursSelect the range of information by clicking the first cell with your mouse and dragging the mouse across all of the rows in a column that you want to selec... Read More »

In excel how can i make a macro to be ran when a workbook is opened?

Within the Workbook Object, use the Open Procedure: Private Sub Workbook_Open() ' ' your code goes here... 'End Sub.