I have the following code I am trying to use this to find the last value grater than zero. This code finds zero values how can I get it to ignor zero values
LastB = Range("B65536").End(xlUp).Row
LastOfAll = LastB
Range("I" & LastOfAll).Select
LastB = Range("B65536").End(xlUp).Row
LastOfAll = LastB
Range("I" & LastOfAll).Select