Thanks again Stephen!

And bobwilko, I'm going to go way out on a limb and attempt to help. Disclaimer: My username should probably be something like "soopervbanoobarific" or something along those lines.

Looking around yesterday for a solution to my problem, I found this:

    Sheet1.Range("A1:A200").Copy 
    Sheet1.Range("A1:A200").PasteSpecial xlPasteValues
Hope that helps, even a little...