You could call a named range or ctrl+shift+enter to run an array command. You couldn't put a defined array in a single cell, it would read at text.