If your only intent in using cell was to trigger a calculate event, then I
guess it doesn't make any difference what value it returns.

--
Regards,
Tom Ogilvy



"JE McGimpsey" wrote in message
...
Tom -

Do you see any difference in terms of firing a Worksheet_Calculate or
Workbook_SheetCalculate event when a sheet in the workbook is renamed? I
don't with MacXL.

I was just thinking of an event trigger. If the filename is to be used,
your addition is obviously the correct one.


In article ,
"Tom Ogilvy" wrote:

Just to add:
Believe
=Cell("filename")

Will return the name of the activesheet, so you might want to use

=Cell("filename",A1)

the second argument can be any cell reference (on the sheet).