finding last edited cell

22strider

Active Member
Joined
Jun 11, 2007
Messages
299
Hello Friends,

Is it possible to find the unsaved data in a spreadhseet/workbook? Or the last cell was edited?

After working on multiple workbooks when I try closing them excel confirms if the changes should be saved or not. I was wondering if there was a way to check what those changes were. If there was a way to find address of the cell that was edited last. This will help figuring out if the file should be saved or not.

Regards,
Rajesh
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

22strider

Active Member
Joined
Jun 11, 2007
Messages
299
Hi, I was hoping to have a macro, running which would highlight last unsaved/edited cell.
Regards,
Rajesh
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,944
Hello,

That will be very easy and impractical, I'm afraid.
You should work with application-level events, which is not easy.

If you need to do this in a dedicated workbook, you could add an event macro in ThisWorkbook: the Workbook_SheetChange event.
It has a number of consequences, such as that the workbook now contains macros.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,992
Messages
5,411,713
Members
403,394
Latest member
Mohan Kumar

This Week's Hot Topics

Top