Thanks for the help here. I appreciate the extra time you spent documenting the process. The checks and bounds placed in the code makes this run rock-solid. There is a slight problem here as I kind of over simplified what I was trying to do here. What I’m doing here is part of several sequences. You had instructed me to put this into a sheet module so that it will automatically fire when the A1 and B1 values are entered. I actually need to run the macro with a button on the worksheet and I’m most familiar with seeing the macro in the macro list. I’m trying to convert this code to do just that and I keep running into errors. Also the cell locations are L4 for the low-value number, M4 for the high-value number and N4 for the results.