May I suggest a new feature? I imagine there's no real hard reason why Data Validation won't take dynamic arrays. It would be amazing to use UNIQUE or even FILT

May I suggest a new feature? I imagine there's no real hard reason why Data Validation won't take dynamic arrays. It would be amazing to use UNIQUE or even FILTER in the Custom format. I've tried all sorts of workarounds including defining named ranges, using INDIRECT, etc. but it seems like I inevitably need to create a range for Data Validation to work Which in turn leads me to think there should be a way to create a virtual Range object in VBA that isn't really in a sheet (or a VirtualRange object that is similar enough to Range to make it work for most purposes). If one were to refactor Range entirely (not suggesting that), it seems like the issue is that the Range object actually encapsulates two different data representations into one jumbled up object: (1) cells in a worksheet with properties such as style, fill, value, etc. and (2) a traversable quasi-array data type with useful methods such as offset, rows, columns, etc. Those two things often line up, but not always. Anyway, I probably spend too much time thinking about Excel :-) </rant>