Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Scipy linear algebra functions in Excel
- Cubic Splines
- Latex Maths Text in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LinEst() on data with gaps
- Section Properties of Defined Shapes - Spreadsheet
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Commenting a block of code in VBA
Recent Comments
Tag Archives: clear range
Writing Arrays to the worksheet – VBA function
Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here. I have now put this code in a function that can be conveniently called from any … Continue reading