Forum Home
Press F1
 
Thread ID: 5504 2000-08-30 02:43:00 Excel 97 Guest (0) Press F1
Post ID Timestamp Content User
6084 2000-08-30 02:43:00 The ?spreadsheets how to? section in the August 2000 issue of PC World showed how to display the worksheet name in Excel using the CELL (?filename?) function.
Good tip but the problem is the formula always displays the path name of the last recalculated sheet. Formulae in multiple worksheets or even other workbooks all display the same name.
Does anyone know of a work-around for this apart from using a macro to recalculate each worksheet.
Guest (0)
1