I am trying to copy a fromulated range but i want to have the values only and excluding the non error #N/A. How can I do it?

[VBA]
Sub copy_not_error_values_only()


If Sheets("Monthly Source").Range("F2") = "HIGH RISK" Then

Sheets("Monthly Source").Range("G4:G161").ClearContents

'*** On this range I only want to copy and paste special values and excluding " #N/A " values since it range is formulated ***
Worksheets("Monthly Source").Range("C400:C5582").Copy _
Destination:=Worksheets("Monthly Source").Range("g4")


End Sub

[/VBA]