count only rows with a value other than 0

		Microsoft Office Forums > Microsoft Excel > Excel Programming
count only rows with a value other than 0

FAQ

Thread Tools

Display Modes

08-04-2018, 02:38 AM

p45cal

Windows 10 count only rows with a value other than 0

Office 2016

Expert

Join Date: Apr 2014

Posts: 962

a guess:

Code:

lngLastRow = Sheets("RISKS").Range("A65535").End(xlUp).Row
Do Until Sheets("RISKS").Range("A" & lngLastRow).Value <> 0
  lngLastRow = lngLastRow - 1
Loop
'now lngLastRow contains last non-zero value in column A

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find duplicate rows in a huge excel file containing 500000 rows	Stc25234	Excel Programming	2	06-23-2017 10:51 AM
Nested tables. Count rows	NevilleT	Word VBA	9	05-10-2017 05:22 AM
Getting the Count formula to count all rows	Jennifer Murphy	Word Tables	11	08-23-2016 09:37 PM
simple way to count rows in a table?	bkcell	Word	4	03-09-2015 09:06 PM
Count rows and add blank rows accordingly	Hoochtheseal	Word VBA	1	01-29-2013 09:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 AM.