Thank you - I would never have thought about that!

The range in question which is supposed to contain 1s is an indicator range that checks whether an entry is duplicated in the current sheet. Somehow I managed to copy and paste a portion of VBA code right below itself, causing a procedure to be executed twice, resulting in there not being any entries whatever left in the relevant sheet.

It's all fixed now, though :-) Thanks!