pasting formulas as values with multiple selections

Hi all,

I am pasting several formulas in a named range with multiple areas. How can I keep the values only once they have calculated? I don't want to use the copy/paste method as it is slower and I would need to do each area of the range separately. I have tried using below ".Value = .Value" method, unfortunately it returns "#NA" for some cells even though the formula returns values??

    With ThisWorkbook.Sheets("PLN").Range("A10:C20,F10:H20,J10:L20")
         .Value = .Value
    End With

Or is there an even better method I'm not aware of?