Across Worksheets Again
 

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: http://www.excelforum.com/member.php...o&userid=33849
View this thread: http://www.excelforum.com/showthread...hreadid=536285

Across Worksheets Again
 

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: http://www.excelforum.com/member.php...o&userid=33849
View this thread: http://www.excelforum.com/showthread...hreadid=536285

Across Worksheets Again
 

Type your name in once.
Name that cell <insert<Name<Define
Type in name for cell (say 3 characters to keep it short)<OK

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

This puts in a reference to that cell.

Regards.

Bill Ridgeway
Computer Solutions

"Triptanes" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=33849
View this thread: http://www.excelforum.com/showthread...hreadid=536285