Difference between revisions of "Excel Macros"
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
* [[Daily Averages 2| General Daily average Macro]] | * [[Daily Averages 2| General Daily average Macro]] | ||
* [[Freezing / Thawing Indices]] | * [[Freezing / Thawing Indices]] | ||
+ | * [[Double Line Delete| Line Deleter for going through online data from shand]] | ||
* [[Cell Wrap]] -- Useful for long column headers in data spreadsheets. | * [[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 | * [[Data Split]] -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel |
Revision as of 11:35, 1 August 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
- MicroMet Format Daily Averages
- General Daily average Macro
- Freezing / Thawing Indices
- Line Deleter for going through online data from shand
- 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