My problem is excel will not allow me to copy & then paste special values -
I am trying to kill vlookup formula's & turn them into safe friendly values.

might you be able to use vba on disconnected ranges.

this question applies to the "copy  - paste special - values" in place
question but this "separate ranges" issue causes me grief in general - I
will gladly apply it to other things as well unless this complicates the
question.

Thanks Todd

        for each myArea in myRange.areas
                'your code here to copy and paste here.
        next myArea

Dave Peterson