Paste special values to a new sheet

[bradyj7]

Hi there,

I need to copy the values in the cells in column AS to column E in a new sheet. However I need to use "paste special values only" because the cells in column AS contain a formula. This is what I have so far but it just returns #REF!

Thanks

Worksheets("raw").Activate
Range("as:as").Copy
Worksheets("graphdata").Activate
Range("e1").Select
ActiveSheet.Paste

 

[VoG]

Try

Worksheets("raw").Columns("AS").Copy
Worksheets("graphdata").Range("E1").PasteSpecial Paste:=xlPasteValues

 

[bradyj7]

Thanks that worked!