View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
CmK CmK is offline
external usenet poster
 
Posts: 69
Default 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
---