Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Contour plots with Excel and Matplotlib
- Retrieving unique values from a range or array ...
- Solving higher order polynomials
- Writing Arrays to the worksheet - VBA function
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
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