Let's see if I understand what you're asking for.....

If you want each sheet to have a cell named "NewRate" that refers to Cell A1
on the current sheet.....

Try this:
Select the cell A1
Then...in the Name Box (just above the Col_A heading)...if your sheet is
Sheet3, type this: Sheet3!NewRate
Press [Enter]

On Sheet 4, you'd name the cell Sheet4!NewRate, etc

Now, whenever you refer to the range NewRate (without the sheet reference),
the formula will point to the cell with that name on the same sheet the
formula is on.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Steve" wrote:

How can I use the same cell name on different worksheets within the same
workbook?

Steve