Thanks a TON wamp, you've cut down my workload immensely. Im definitely giving you good feedback.

I have a couple of questions though if you could humor me.

Here are my assumptions about your code:
1. Dim i assume is the name of a new expression or variable,
2. Set is predefining a variable with a string or integer
3. range is from column a to b, where the : ties the two together as a range.
4. MsgBox generates a message box that is pre-coded into excel to be maniuplated.
5. vbNullstring is another way of saying = 0

Heres we're my knowledge gets fuzzy:
What is the R.select?
How come you have Dim's starting half way into the program?
You exit as Sub up top, but then exit it again half way without declaring a new sub.

Cheers Wamp, have a good one!
Alkatraz