perhaps
   For Each cell_Check In range_ValidRows
   '''set the variables required for the method and error check'''
   
      If Application.WorksheetFunction.Count(cell_Check.Offset(, -1).Resize(4)) = 4 And Application.WorksheetFunction.CountIf(cell_Check.Offset(, -1).Resize(4), ">0") = 4 Then
         int_FirstYear = cell_Check.Value
         int_Frequency = cell_Check.Offset(0, 1).Value
         int_Spread = cell_Check.Offset(0, 2).Value
         long_Cost = cell_Check.Offset(0, -1).Value / cell_Check.Offset(0, 2).Value
         
         '''Continues with the rest of the function code
      End If
   Next cell_Check