ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   List function, convert to range (https://www.excelbanter.com/new-users-excel/198098-list-function-convert-range.html)

Simon[_2_]

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

Matt Richardson

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com