Excel iconVBA icon

Quickly Clear Conditional Formatting

Here is a simple sub that deletes conditional formatting from a selection. The code does some prelim checking to see that it is actually acting on a range, and it mimics Excel's usual behavior (like a good VBA procedure should, if I may say so) by acting on the entire worksheet if you only select a single cell. However I recommend just selecting the range before you run the code.

Continue Reading: Quickly Clear Conditional Formatting »

Automation iconWord icon

Simple Word macro/button to print out a form

Happy April Fool's Day!

Here is a simple macro in MS Word that you can use to print out a document to the default printer.

Continue Reading: Simple Word macro/button to print out a form »

AddIns iconExcel iconVBA icon

Data Filter Tool and dmoz.org announcement

Good morning,

I am pleased to announce that the Data Filter Tool add-in has been completed. I will be posting a fuller announcement on The Coding Pad, but for now I would like to make this add-in available for anyone who wants to try it.

Continue Reading: Data Filter Tool and dmoz.org announcement »

Automation iconWord icon

Automated Word Mail Merge from Excel

Greetings,

I just updated the site with some code for automating the mail merge to Word process. Check it out here:

Excel Mail Merge

Enjoy,
JP

Administrative icon

Website stats

Here are some visitor stats for the site Code For Excel And Outlook:

Continue Reading: Website stats »