If a condition is met convert range to value from formula

Good Afternoon All

First I just want to thank everyone on here regardless of solution. I have been following this board for a while and this site has always helped me expand my knowledge of VBA. I am no expert by any means but i now enough to get myself into trouble.

Image if you will of a spreadsheet where in column A you have a drop down with two options to pick from open and close.

Columns B - E have formulas in them that pull from another sheet (specifically vlookup formulas)

What i am trying to accomplish is this. If a person selects close from the drop down in column A, columns (B-E), on that row, gets converted from the vlookup formula to its value.

I have tried writing this a number of way but either excel says that there is a problem with the code or i get the wrong result. I just can't seem to get it to specify to the specific rows that meet the condition. This is the closest working code that i have so far:

Sub Celladjust()

 Dim rng As Range
    
   Set rng = Range("A:A")
   For Each Cell In rng
       If Cell.Value = "close" Then
    Columns("B:E").Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    End If
    Next
End Sub

I have tried specifying range for rows but I am doing something wrong.

If someone can help point me in the right direction with this that would be amazing.
Thank you all.
MG