Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Frame Analysis with Excel - 3, Continuous beam or frame
- Retrieving unique values from a range or array ...
- Filling Blanks with Go To-Special (and local help rant)
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