sheetname

  • Thread starter Thread starter peter
  • Start date Start date
P

peter

Hi,
After saving a test file...
I put this formula in a cell on sheet1, it returns the
proper info.
=cell("filename")
I then go to sheet2 and hit f9.
If I return to sheet1 it now has the value of sheet2.
why????
Is there someway to get this formula to always return the
sheet name of the sheet the formula is in without having
to hit f9???
Is there any formula(function) that will return the sheet
name without having to hit f9?
using excel xp
peter
 
Hi Peter
you have to add a reference to your worksheet. Otherwiese CELL(...)
will use the last active sheet. so try:
=cell("filename",A1)

Frank
 
You need to include the reference argument:

=CELL("filename", A1)

or, if entered into a different sheet

=CELL("filename",Sheet1!A1)

otherwise CELL returns the name of the last sheet calculated.
 
Back
Top