You didn't specify but try this idea
for each c in range("a1:c100")
if c=2000 then c.clear
next c

--
Don Guillett
SalesAid Software

"joecrabtree" wrote in message
ups.com...
To all,

I have a worksheet full of numbers ( DATA1 ), I want a macro to be able
to go throught this worksheet, and delete all values that are greater
than or equal to 2000. Any ideas?

Thanks in advance

Joseph Crabtree