I have a range of cells that I wish to find the max and min of. The only problem is that occasionally this range has a vbString or vbError in it. Is there a way to use SpecialCells so that only the numbers are evaluated? Right now my max and min are both coming back as #N/A. Thanks.