Hello, I have the following code written into a module right now 
Function ColorAndName(ColRng As Range, NameRng As Range, Nme As String, coloffset As Integer)
  Application.Volatile
  lcolor = ColRng.Interior.ColorIndex
  total = 0
  For Each ce In NameRng
    If ce.Interior.ColorIndex = lcolor And ce.Value = Nme Then
      total = total + ce.Offset(0, coloffset)
    End If
  Next ce
  ColorAndName = total
End Function
It is making my spreadsheet calculate constantly when I am entering data. I need this code however to calculate my sheet when I am done entering data after several days. Is it possible to make it into a macro I can tell to run when I am ready? Thanks for your help