Hi all, I have this code which works fine for copying ranges from multiple sheets to a Master sheet. What I need to do is paste the values as some of the copied cells do contain formulas & I have played around but cannot work out where to place "PasteSpecial Paste:=xlPasteValues". Thanks for any help provided.
VBA Code:
Sub COPY_RESULTS_TO_MASTER()
Dim ws As Worksheet, lr As Long
lr = Sheets("Master").Cells(Rows.Count, "A").End(xlUp).Row + 1
For Each ws In Worksheets
If ws.Name <> "Master" Then
ws.Range("T1:AH60").Copy Sheets("Master").Range("A" & lr)
lr = Sheets("Master").Cells(Rows.Count, "A").End(xlUp).Row + 1
End If
Next ws
End Sub