If you look at the .specialcells suggestion, you'll notice that it only looks at
cells with number constants.



wrote:

<<snipped

Thanks everyone soo much for your help! It's amazing what Excel can
do!
I used Bob's one and it worked well.
I wonder as an added feature needed is it possible to also change the
macro that it does not delete formulas if there are formulas in the
column?
I just want it to reset cell values that are greater then 0 and not
over-write formulas?

Thanks!

--

Dave Peterson