use

=YourRange

press enter, select the formula in the formula bar and press F9, copy.
Note that named formulas can only hold I believe 255 characters

--

Regards,

Peo Sjoblom

"nospaminlich" wrote in message
...
Just a thought....

The array here is relatively quick and easy to type in. If you wanted to
use the same principle for a much larger array is it possible to convert
info
in a range of say A2:C40 into a format that could be copied into the
Define
Name box thus allowing the info in those cells to be deleted? If so, how?

Thanks a lot