Example: My Name "RevBalance" has Workbook scope, and the following formula:
Please Login or Register  to view this content.
I created it on the 'Chase Acct' worksheet; on the "Scottrade Chkg Acct" worksheet it should reference:
Please Login or Register  to view this content.
and so on.

If I delete 'Chase Acct'! from the formula above, Excel just reinserts it. How can I make a formula relative the to current active cell, in the same way I can pick whether to use the cell below the active cell, or a specific row/column reference?