Thanks! Tried editing the code but an error comes out. It says that there is no object defined. I think C was not declared? anyways here's my code

For Each c In Range("O5:O16, P5:P16")
Next c
If c.Value = "" Then c.Select
If c.Value <> "" Then
saveRecords
ActiveWorkbook.Save
End If