Macro - copy value only from multiple sheets into one sheet

Hello,

I have been struggling with this Macro for a while and I have tried in every way that's suggested on the web. This Macro works fine to copy data from multiple sheets into one master sheet, but it is also copying the formula. How can I change this Macro so that it is copying and pasting VALUE only?

Sub Combine()
Dim J As Integer

On Error Resume Next

' work through sheets
For J = 4 To Sheets.Count ' from sheet 3 to last sheet
Sheets(J).Activate ' make the sheet active
Range("A10").Select
Selection.CurrentRegion.Select ' select all cells in this sheets

' select all lines except title
Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select

' copy cells selected in the new sheet on last line
Selection.Copy Destination:=Sheets("Combined").Range("A65536").End(xlUp)(2)

Next
End Sub

Please help. I need to resolve this quickly.

Thanks,

Yang

Welcome to the forum. Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used. (Like I did below...)

Please Login or Register  to view this content.

Easy and quick solution is ready, I'll post it after you fix your post above.

Thanks! I have updated it.

Really appreciate in advance for your help.

Try this:

Please Login or Register  to view this content.