Legacy Range from Filtered Column

[HansS]

Hi @jcmargeson welcome to the forum

Maybe the Domain Calculator fixes your problem.
gr. Hans