Posted to microsoft.public.excel.misc
|
|
How to apply a name to a cell range
Cheers it works sorry
"Max" wrote:
"CmK" wrote:
It doesnt work only the figure in the first cell shows in the range
Thought my response mentioned that it should be array-entered:
.. into a horiz range of the same size -- select 12 horiz cells ..
If you array-enter the defined range into a single cell, then it shows only
the 1st element. Array-enter into 2 horiz cells, it'll show the first 2
elements, and so on. You can try this and see for yourself.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
|