Paste as Values vba

[namluke]

Hi I have code below which copies data from one sheet and pastes to the select other sheet.

How can I get this code to paste in values only??

sub CopyPaste()
Dim ws As Worksheet
For Each ws In Worksheets

If ws.Name <> "Sheet1" Then

ws.Application.Run "Macro1"
End If
Next
End Sub

Sub Macro1()
Range("A2:B13").Select
Selection.Copy
Sheets("sheet2").Select
ActiveSheet.Paste
End Sub

[judgeh59]

try this

Please Login or Register  to view this content.

[AB33]

You need cell reference to paste, you can not paste in to active cell.

Please Login or Register  to view this content.

[namluke]

Thank you very much, helped a great deal.