Excel Macros

Handy Code Snippets

This page contains links to several Excel Macros. Feel free to use or add additional ones.

• Save Macros in Excel-- a brief How-To
• Create a Toolbar button -- a brief How-To (useful with some macros)
• Julian to regular date converter
• Regular Date to Julian Converter
• Calculate Daily Averages / Sums from hourly data
• Freezing / Thawing Indices
• Cell Wrap -- Useful for long column headers in data spreadsheets.
• Data Split -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel