Difference between revisions of "Excel Macros"
Jump to navigation
Jump to search
imported>Bob |
imported>Bob |
||
Line 1: | Line 1: | ||
== Handy Code Snippets == | == Handy Code Snippets == | ||
− | This page contains links to several Excel Macros | + | This page contains links to several Excel Macros. Feel free to use or add additional ones. |
* [[Save Macros in Excel]]-- a brief How-To | * [[Save Macros in Excel]]-- a brief How-To | ||
+ | * [[Tool Bar Button|Create a Toolbar button]] -- a brief How-To (useful with some macros) | ||
* [[Julian to regular date converter]] | * [[Julian to regular date converter]] | ||
* [[Regular Date to Julian Converter]] | * [[Regular Date to Julian Converter]] |
Revision as of 11:18, 12 March 2008
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