terrific freeware utility called Name Manager, by Jan Karel Pieterse. You
can find it at:
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp
I use names a lot, because it makes it much simpler to refer to cells from
VBA. This Add-in makes it easy to manage names -- creating, editing,
hiding, changing scope, etc. It's a great tool.
-- Joel
Joel C. Adair, P.E.
Project Manager
the structural alliance, Inc.
9401 LBJ Freeway, Suite 107, Dallas, TX 75243
T 469.330.5200 F 469.287.4334
-----Original Message-----
From: MICHAEL LeCOMTE [mailto:michael_lecomte@hotmail.com]
Sent: Tuesday, March 27, 2007 9:36 AM
To: seaint@seaint.org
Subject: Re: Sharing Neils tip on Neat Excel Equation Writer
A shortcut to using insert>name>define:
There is a "name box" just above column A, typically it shows "B2" if you
are in cell B2. If you click into the "name box" you can just type the
"name" you want and it does the same as insert>name>define.
If you want to put a "name" into a formula, mid formula you can hit F3 and
it brings up a list of the previously defined names.
_________________________________________________________________
Live Search Maps - find all the local information you need, right when you
need it. http://maps.live.com/?icid=hmtag2&FORM=MGAC01
******* ****** ******* ******** ******* ******* ******* ***
* Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*
* This email was sent to you via Structural Engineers
* Association of Southern California (SEAOSC) server. To
* subscribe (no fee) or UnSubscribe, please go to:
*
*
http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad@seaint.org. Remember, any email you
* send to the list is public domain and may be re-posted
* without your permission. Make sure you visit our web
* site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********
******* ****** ******* ******** ******* ******* ******* ***
* Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*
* This email was sent to you via Structural Engineers
* Association of Southern California (SEAOSC) server. To
* subscribe (no fee) or UnSubscribe, please go to:
*
*
http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad@seaint.org. Remember, any email you
* send to the list is public domain and may be re-posted
* without your permission. Make sure you visit our web
* site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********