Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Smart Indenter and Excel 2013
- Buckling of columns with varying cross section
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Converting from global to local coordinates (and vice versa)
Recent Comments
Tag Archives: modify range
Modifying spreadsheet data with VBA – the quick way
A question recently came up (here) asking how to speed up the process of scanning a large range of data on one sheet, and wherever a cell had a value of zero, deleting the data in the same cell address … Continue reading