You can get the sheet name with this formula:
=RIGHT(CELL("filename",A1),(LEN(CELL("filename",A1 ))-FIND("]",CELL("filename
",A1))))

I have lost track of the post whcih you mention.

Mangesh




"Summer" wrote in message
...
Mangesh,

Tried your code. This is so cool! (I'm a newbie - only 3 wks with Excel)

I'd like to take this code you posted for the OP and use it a different
way.
I am curious...Can this be done?:

Have the Log sheet store "historical" changes, logging only a finite
number
of them (overwriting oldest log entries as newer ones are returned)? Can
the
Log
sheet also return the Sheet Name that was edited? My idea is to have
something *similar* to an "Audit Trail".

Example of proposed Log sheet:

Sheet Name......... Date & Time............. Cell Address(es)


.........A.................B...................... ...........C...............
1......CustList......6/16/2005..13:09........$A$23:$B$24
2......Products.....6/16/2005 13:15........$D$678
3......CustList......6/16/2005 13:22........$G$567:$K$567
4......CustList......6/16/2005 13:25........$A$567:$E$567
etc...

Hope this makes sense.
--
Summer