Macro To Paste / Values Only In Specified Range

I have the attached macro that runs goes through files in a folder and "flattens" (removes formula to make them values) and deletes a worksheet.

I was wondering if the macro can flatten only a specified range in the "Master assignment sheet".

I want the macro to only paste/values in range B1:E4500 and G1:G4500.

Code:
Sub Modify_Files()
'Opens all files in the current folder.
'Unprotects Master assignment sheet and transforms all formulas to values.
'Deletes sheet Zip codes.
Dim Filename As String
Dim WB As Workbook

[Code] ......