Hi,

I have a work sheet that has lots of data in and gets regular updates. I'm able to to copy data from 3 columns and paste into a different sheet via a simple macro but I'm having issues of selecting only the cells with data and not the "empty" cells with a formula. i.e. the empty cells with formulas will eventually get data when it is added, but until then I don't want to copy the data across.

The below is what I'm using and had hoped the xlPasteValues would have been the fix but is copying "blank" cells in exchange of the original formula. Does Copy have any options or alernatives? 

 
Sub TestData()
    Sheets("RawData").Select
    Range("S:U").Copy
    Sheets("Sheet1").Select
    Range("A1").PasteSpecial xlPasteValues
End Sub

Thanks,
Neil