Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Alternative iterative solvers
- Latex Maths Text in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Taming Symbols in Excel
- Automating chart scale limits - update
- Beam actions and deflections by Macaulay's Method
- 3D Frames, axes and stiffness matrices
- Frame Analysis with Excel
- Contour plots with Excel and Matplotlib
Recent Comments
Tag Archives: slicing arrays
Slicing Arrays with VBA
A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading