I am trying to copy a range and paste it as values using vba but it seems like it steps through the codes but didnt do anything since I still have formulas after I ran it.
Column R and S are the only places that have formulas and I tried F8 and it steps through everything just didn't do its work? Maybe I got the wrong codes for pasting as values but here they are. All the columns have the same # of rows. So there is no error just didn't copy and paste as values.
If someone can recommend a more efficient way to copy and paste a range as values only, please share as well.
Sub test() Dim ws2 As Worksheet Dim LR3 As Long Set ws2 = Worksheets("BRST") LR3 = ws2.Cells(ws2.Rows.Count, "R").End(xlUp).Row ws2.Range("R3", "S" & LR3).Copy ws2.Range("R3", "S" & LR3).PasteSpecial xlPasteValues End Sub