Excel Tips
Add a Percentage in All Cells in a Range »
January 30, 2002
How to add a percentage in all cells in a range.
Event Macro To Change Excel Header »
January 29, 2002
How to get the path where the document is filed indicated in the header or footer - or anywhere in the document.
January 29, 2002
Sometimes, the InputBox function just isn't enough, you need to let the user point to a cell instead of having to write in what you want.
Changing Cell Background Color »
January 28, 2002
How to modify the background color of a cell using VBA.
Multiple Lines in Message Box »
January 27, 2002
How to break an expression of Msgbox into 3 lines and insert a blank line into such an expression.
Linking Dropdowns with Data Validation »
January 26, 2002
One good use of Data Validation comes when there's a need to link two or more dropdown list, making them dependant.
Adding Every Other Cell in a Column »
January 24, 2002
Is there a quick way of adding every other cell?
Convert Seconds to Time Format »
January 23, 2002
How can I format a cell that has data in seconds to show it as hours:minutes:seconds?