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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

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,090,490
Messages
5,414,849
Members
403,549
Latest member
CascadeDiver

This Week's Hot Topics

Top