Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- Daily Download 4: Continuous Beam Analysis
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Downloads
Recent Comments
Tag Archives: copy non-blank rows
Copy non-blank rows to another sheet
A thread at Eng-Tips asked for a way to display the data from Sheet2 on Sheet1, but only the rows that were not blank in Column A. There are probably ways to do it without VBA, but it seems to me … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Array Function, copy non-blank rows, Excel, UDF, VBA
3 Comments