rows count if value greater > zero

[jprlimey]

With a range that is sorted from highest to lowest values, can the .rows.count be adjusted to capture the range of values that are greater than zero

Please Login or Register  to view this content.

[stnkynts]

Very limited information. Do you mean like this?

Please Login or Register  to view this content.

[jprlimey]

I modified the code to the following

Please Login or Register  to view this content.

and then added the icount to the following and it solved my problem, thanks for your assistance

Please Login or Register  to view this content.