Deleting a range of cell values from column

[quirk]

Hi all. I really appreciate this forum and it has helped me a great deal in using excel macros (and kind of learning a little VB code). So thanks to you all who post.

It seems silly, but I can't seem to find code to replace or delete a range of numeric values in a column.
That is, I have a large data set (~9000 rows of reaction time data) and I need to delete a range of values (all time values below 400 in column C) but I only want to delete the value in the cells (not the row). I would also like to know how many cells met this criteria.
Any help would be appreciated!

[StephenR]

Why not use AutoFilter. You can use Countif formula to find out how many.

[Oredigger90]

example before and after file would help greatly quirk

[quirk]

Thanks Stephen!
I did use autofilter and countif. I didn't figure out if autofilter could handle deleting values (I thought it primarily removed rows from view) but I was able to work around it and delete the cell values without losing the rows.