About & Introduction

I use and misuse Excel and have collected and modified scraps of macros to create various utilities and programs.

They evolved from a need that wasn't found by searching the internet.

All contain macros so they will only be useful on Excel Professional. I have only run them on Excel 2010/Win 7.

Often, other peoples' code snippets have been modified or combined to suit what I wanted. They were generous to share their code and help, to me and countless others. Thank you very much to all.

They are used in my own work or play, but not by others. So I have been lazy about writing rigorous error-checking in the code. None of them crash Excel or Windows though, so they aren't dangerous as far as I know. (An exception is the America's Cup viewer which can has memory leak if it is not exited correctly. I think this is fixed)

Future postings:
Comment if you want to influence how soon I get around to posting them.

XY chart utilities

• 1:1 scaling
• duplicate series
• change sheet name after copying chart to another sheet
• zoom box
• colour series by another variable:
  
• 
  
• 
  
• Geometry
• DXF polyline to points file
• 
• 
  
• copy cells and paste into Rhino as Pline. This,
• 
  
  
• to this in 4 clicks
• 
  
  

• Ranking Visualisation 
•