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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

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.
 

Forum statistics

Threads
1,089,678
Messages
5,409,695
Members
403,276
Latest member
Oscar007

This Week's Hot Topics

Top