I am receiving a type mismatch on the line below and am not sure how to make the correction.
If .Cells(E, 30 + D).value = "#DIV/0!" Then
The target cell at the moment of the error has "#DIV/0!" as its contents.
The line exists within a with statement:
With wkbk.Sheets("Ratios")...