John,

You're a gentleman and a scholar! Not to mention an powerpoint WIZARD. This seems to work about as well as one could ask for.

However... if one wanted to be nit-picky... they perhaps could ask if there was a way for the formatting to carry over as well? For some reason, not only when I run this code, but also when I copy from word or elsewhere and paste into a blank cell it automatically pastes in white font (I have already looked at the default paste settings). Any ideas?? Or am I just getting greedy at this point.

I have a quick question about mailing labels too if you feel like attacking that as well.

THANKS!!!!