Custom Office Programming and Automation
In Which macro shortcut keys do you use I posted the code I use to clean up my worksheets. Since then I've revised the code somewhat. The fact that my computer crashed and I lost my personal.xls workbook had absolutely nothing to do with this decision.
Continue Reading: Clean up your Worksheet »
In my line of work, presentation is everything. So I like to make sure my worksheets look professional without too much effort.
Continue Reading: Better Worksheets for Printing »
Lately I've been working with a spreadsheet that imports data from a database application (Access). The numbers are formatted as text because some of them contain letters. So the whole field has to be formatted as text. 
Then again, I'm not sure if the text formatting is because of that, or if it's just a function of being a foreign data source.
Continue Reading: Convert Range to Numbers »
When I'm doing a lot of sorting I use these two procedures to sort my used range. I've assigned them to toolbar buttons; just select the value you want to sort on and click the button to sort.
The first one sorts ascending; the second, descending.
Continue Reading: Two sorting macros »
Follow Me