Format header row

Friday, July 11th, 2008 335 views

So I was getting tired of constantly formatting the header row on whatever spreadsheet I am working on, hence this short sub was born. It pretties up the header row and adds autofilter arrows. Most importantly it autosizes the columns so all the information is visible. I chose Teal (ColorIndex ...

Posted in Excel, VBA | No Comments »

Data Filter Tool and dmoz.org announcement

Saturday, March 29th, 2008 25 views

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. Link: Data Filter Tool Add-In Enjoy and please ...

Posted in AddIns, Excel, VBA | No Comments »

Data Filter Tool Add-in Update

Tuesday, March 11th, 2008 23 views

Here is the screenshot of the Data Filter Tool I promised (sorry it's late!): I have been doing a lot of testing, refining the code, etc.. and it seems to be working well. I expect to release this add-in within the next week after some final testing. Enjoy, JP

Posted in AddIns, Excel, VBA | 3 Comments »

Data Filter Tool Add-In - Coming Soon

Wednesday, March 5th, 2008 17 views

I am working on an Excel add-in called 'Data Filter Tool' that lets you auto-filter a range and copy or move matching rows to a new workbook. It is similar to Ron de Bruin's EasyFilter (EasyFilter Add-In), but much simpler and easier to use (in my opinion) because it is ...

Posted in AddIns, Excel, VBA | No Comments »