software

How would I make my name appear in cell D9 on every worksheet in the
workbook with out manually inputting my name into every worksheet
(there are 240!).--
Triptanes
------------------------------------------------------------------------
Triptanes's Profile: www.excelforum.com/member.php...oamp;userid=33849
View this thread: www.excelforum.com/showthread...hreadid=536285
O nm I figured it out, select first worksheet hold down shift click last
worksheet, enter my name in D9, voila!--
Triptanes
------------------------------------------------------------------------
Triptanes's Profile: www.excelforum.com/member.php...oamp;userid=33849
View this thread: www.excelforum.com/showthread...hreadid=536285Type your name in once.
Name that cell lt;insertgt;lt;Namegt;lt;Definegt;
Type in name for cell (say 3 characters to keep it short)lt;OKgt;

In each of the worksheets-
Highlight the cell to contain your name
Click on quot;=quot;
Highlight the cell containing your name
Hit enter

This puts in a reference to that cell.

Regards.

Bill Ridgeway
Computer Solutions

quot;Triptanesquot; gt; wrote
in message ...
gt;
gt; How would I make my name appear in cell D9 on every worksheet in the
gt; workbook with out manually inputting my name into every worksheet
gt; (there are 240!).
gt;
gt;
gt; --
gt; Triptanes
gt; ------------------------------------------------------------------------
gt; Triptanes's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33849
gt; View this thread: www.excelforum.com/showthread...hreadid=536285
gt;