Can you make me an Excel Conditional Row Delete Macro?

Answer 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 »

Top Q&A For: Can you make me an Excel Conditional Row Delete...

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

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 »

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.

How to Apply Conditional Formatting in Excel?

Spruce up important spreadsheets with conditional formatting to make them easier to read.Do you ever need to know when you are over or under budget? Want to pick out an important data from a huge l... Read More »

I need help with conditional formatting in Excel....?

Since you state the "entire workbook", the first thing you need to do is select all of your worksheets. Do this by clicking the very first one, and then while holding down the SHIFT key, click the... Read More »