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
Bookmarks