You won't be able to use worksheet functions to create a contiguous range
from non-contiguous references.

I wasn't trying to. I was trying to define a range of non-contiguous
cells.