- Using LINEST for non-linear curve fitting
- Downloads by category
- Commenting a block of code in VBA
- Drawing in Excel 7 - Creating drawings from coordinates
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Using Goal Seek on Multiple Cells
- Lateral pile analyis with PY curves ...
- Cubic Splines
- Retrieving unique values from a range or array ...
I have previously linked to a spreadsheet stored on Skydrive, but I have been disappointed that the possibilities for using live spreadsheets are greatly limited by the lack of support for VBA. It seems that Microsoft have now decided to provide … Continue reading
Since this is not (just) an Excel blog, I’ll be looking at applications of the Google Docs spreadsheet. One of the attractions of the Google spreadsheet alternative is that it is linked to a scripting language, so I should be … Continue reading