I am copying a group of cells and want to paste the values into another excel worksheet. If I do paste then this works, unfortunately giving me #REF (they are referenced cells). I only want the values copied. Trying Paste Special Values results in an error - cells must be identically sized. I have resized the target to no avail, Any thoughts? All other Paste Special options (formulas, formats, comments etc.) work fine, i just want the values!