VBA reset cell value if greater then 0
On Jan 17, 1:42*pm, Dave Peterson wrote:
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
Thanks everyone for your suggestions!
I got the macro to work!
All your tips were useful!
|