In my worksheet, I have 2 contiguous ranges: A1:A10000 which generates numerical values in all cells. The generation of values in A1:A10000 can be divided in 2 parts
Part1: It generates numerical values >0 and is contiguous
Part2: It generates 0 (zero)
Example: If A1:A333 >0, then A334:A10000 =0...