Not really, because it works by picking up the value in the previous cell. That previous cell doesn't have to be A1, B1,C1, and so on, it can be A1, D4, G7, etc., as long as the sequence is consistent.

I suppose that you could do it by declaring a sequence range that you use in a selection change event to re-create the ColListNum defined name, like this