Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
Public Function CountDataRows() As Long 'Counts the number of non-blank cells from a START cell range. Loops through the range until empty cell is found. Returns the total number of rows that contain data within the 'specified range/column. Note: Is dependant on each row having a value. Dim wks As worksheet Dim wkb As Workbook Dim rng As Range Dim Counter As Long Set wkb = ActiveWorkbook Set wks = wkb.Sheets("Test") Set rng = wks.Range("testrow") With wks Counter = 0 Do Until wks.Range("testrow").Offset(Counter, 0) Is Not Empty Counter = Counter + 1 Loop End With CountDataRows = Counter End Function
|How do I enter a formula in Excel to capture a part of text from a cell?||7||27|
|Thanks for the advise, but...||4||24|
|Excel 2003 Conditional Formatting for Jan 1||3||13|
|Excel Array formula issues||4||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!