Function SheetName()
SheetName = ActiveSheet.Name
End Function
=CELL("filename",A1)Thanks for your quick response. I'll give them a shot.
Tried the three of them and all worked. don't understand how that formula works, can you explain it to me please?
thanks