I have the following block of numbers in a worksheet (let's say Sheet1), the
column ranges named T1, T2, T3, T4 and T5:

T1 T2 T3 T4 T5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 5 7
1 2 5 7 10
1 2 5 10 12
1 2 5 10 15
1 2 5 10 15
1 2 5 10 15
1 2 5 10 15
1 2 5 10 15
1 2 5 10 15

In the same sheet, I can put together an array formula that refers to the
whole block by using the syntax T1:T5. However, if I try to use the same
array formula in a different sheet using Sheet1!T1:T5 I get #VALUE. Can
anyone tell me what's wrong with my syntax and if there's any way of
referring to this range in another sheet in terms of the existing range names
(I don't want to use cell references, i.e. A1:E14)?