How do I expand the Name Box?
When I name a range, it is posted to the Name Box (next to the formula bar).
However, the full name is not displayed due to the size of the name box. Thanks. |
See http://www.xldynamic.com/source/xld.Names.html#misc
-- HTH Bob Phillips "JohnnyQuick" wrote in message ... When I name a range, it is posted to the Name Box (next to the formula bar). However, the full name is not displayed due to the size of the name box. Thanks. |
You can do this only through code. See
http://www.cpearson.com/excel/NameBox.htm for details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JohnnyQuick" wrote in message ... When I name a range, it is posted to the Name Box (next to the formula bar). However, the full name is not displayed due to the size of the name box. Thanks. |
Thanks Chip. I appreciate it!
"Chip Pearson" wrote: You can do this only through code. See http://www.cpearson.com/excel/NameBox.htm for details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JohnnyQuick" wrote in message ... When I name a range, it is posted to the Name Box (next to the formula bar). However, the full name is not displayed due to the size of the name box. Thanks. |
Thanks Bob. Both you and Chip gave me the solution.
"Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.Names.html#misc -- HTH Bob Phillips "JohnnyQuick" wrote in message ... When I name a range, it is posted to the Name Box (next to the formula bar). However, the full name is not displayed due to the size of the name box. Thanks. |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com