to find the Last Modified cell in excel

[lokeshsu]

Hi all,

Do we have a macro which finds the last modified cell in the excel sheet. if it is there please help us with the code.


Thanks In Advance
Lokesh Sundar

 

[Weaver]

Not sure what you need to do with this, but the following might help

Open up the vb window and click on 'thisworkbook' in the project window

Paste the following code

Dim ws As Worksheet, rng As Range
 
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Set ws = Sh
    Set rng = Target
End Sub
 
Sub gotoLastModified()
    on error resume next
    ws.Activate
    rng.Select
End Sub

Now if you use alt-F8 and run the 'thisworkbook.gotolastmodified' module the last modded cell in the sheet will be selected.

HTH

 

[turist]

Not sure what you need to do with this, but the following might help

Open up the vb window and click on 'thisworkbook' in the project window

Paste the following code

Dim ws As Worksheet, rng As Range
 
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Set ws = Sh
    Set rng = Target
End Sub
 
Sub gotoLastModified()
    on error resume next
    ws.Activate
    rng.Select
End Sub

Now if you use alt-F8 and run the 'thisworkbook.gotolastmodified' module the last modded cell in the sheet will be selected.

HTH

When the file save and closed. Then reopened 'thisworkbook.gotolastmodified' does NOT go the last modified cell. Only goes last cell where cursor is.

Is there any idea to find the last modified cell (or the cell last inputted any data)?

Thanks and regards.
turist