Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnston
 
Posts: n/a
Default Name Define

Hi ,

I have a rather long formula which has been given a name.

I need to edit it occasionally but when I choose INSERT - NAME - DEFINE and
choose the "name" the formula appears in the refer box as expected. However
only the first 63 characters can be edited. I cannot scroll along to the
remaining characters. At the moment I am having to rewrite the formula
again.

Anyway around this without resorting to writing the formula into a cell
rather than the defined name?

Ken


 
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
Define Names in Excel Dave T at home Excel Discussion (Misc queries) 2 November 1st 05 03:27 PM
Define a chart using VBA Pim Charts and Charting in Excel 1 September 27th 05 10:57 PM
alternate UI for Define Names ?? jmg092548 Excel Discussion (Misc queries) 2 August 11th 05 01:32 PM
Define Name use in Macros Bill Christian Excel Discussion (Misc queries) 3 July 15th 05 03:43 AM
I can define a name, but I cannot use the name - menu Insert-Name-Use is blank Zdenek Moravec Excel Discussion (Misc queries) 4 April 15th 05 02:55 PM


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