Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 89
Default List function, convert to range

Hi, This is always grayed out when I try to use it.

How can I select this opton? I've sorted my data.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 59
Default List function, convert to range

On Aug 8, 10:38*am, Simon wrote:
Hi, *This is always grayed out when I try to use it.

How can I select this opton? *I've sorted my data.

Thanks


You have to have used ListCreate List... first. Once you've done
that you can convert to a range.

HTH

Mat
http://teachr.blogspot.com
Reply
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 to convert vertical blocked list to horizontal list? G Lykos Excel Worksheet Functions 8 May 17th 23 07:45 PM
List function: Convert to Range Simon[_2_] Excel Discussion (Misc queries) 1 August 8th 08 01:07 PM
Convert an Excel list to a Range ryguy7272 Excel Worksheet Functions 3 April 2nd 08 05:29 PM
Condensing a list/range with blank cells to a new list/range without blanks KR Excel Worksheet Functions 4 July 5th 05 04:23 PM
Function that filters a list (Database) for criteria in a range a. FirstVette52 Excel Worksheet Functions 0 February 8th 05 04:37 PM


All times are GMT +1. The time now is 11:52 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"