Thread: count only rows with a value other than 0
View Single Post
 
Old 08-02-2018, 04:51 AM
Homegrownandy Homegrownandy is offline Windows 10 Office 2016
Novice
  
Join Date: Jul 2018
Posts: 14
Homegrownandy is on a distinguished road
Default count only rows with a value other than 0
Im using code to copy rows from excel and paste them into a word table. The problem is its including zero (0) value cells as they are from a formula.


In the advanced options for the worksheet I have turned off the option to display the 0 but still it will copy these cells.


To count i am using this code



Code:
lngLastRow = Sheets("RISKS").Range("A65535").End(xlUp).Row
If anyone has a sugestion i would appreciate it.

its worth mentioning that behind the value its a formula.
Reply With Quote