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!