My followup question is:

I would like to manually select a range of cells and then click the macro to search the values of each Selected cell, then replace values below -100 or above 300 with "" or no value.

Thanks!

-Troy