That helped out some, taught me a cleaner way to code. I am still getting a "run time error-'9' Script out of range" message when another spreadsheet is open and in use. Any way to fix this problem?

Rep for the cleaner code!