"Ryan RBG" wrote ...

With the little knowledge of programming that i have, that looks like it
would work. However, i am unfamiliar with where to put that code in excel!
Where would i plug that code in to make it work? Thanks for your help.

Put it in a standard module in the workbook containing your data and
change the XXX to the actual name of the sheet containing your data.
As always, take a backup copy of your workbook first!

Jamie.

--