LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jack Sheet
 
Posts: n/a
Default Mental block

How do I define an array constant as a name?
I tried to insert a name as follows
Name: 2006!AgeRange
Refers to: ={<16,17-18,19-49,49}
and it advised that the syntax was incorrect but was otherwise unhelpful.
I tried substituting ";" for "," as the element separators but that didn't
help either.
Thanks

--
Return email address is not as DEEP as it appears


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get a long block of wrapped text to print? DianeWms Excel Discussion (Misc queries) 3 February 8th 06 03:30 PM
copy a block of cells florin Excel Discussion (Misc queries) 2 October 12th 05 03:16 PM
How to copy block of cells and keep grouping? dstock Excel Discussion (Misc queries) 2 July 6th 05 08:42 PM
Changing the format of a block of data Greg Excel Discussion (Misc queries) 0 January 23rd 05 02:30 AM
copy a sheet in same workbook temporary block excel mircea Excel Worksheet Functions 0 January 22nd 05 12:23 PM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"