Go to last modified cell in other worksheets

Hi,

Im trying to create a code that takes me to the last modified cell between all other worksheets (except the active worksheet). i have the below code but its not working.

any help to rectify would be much appreciated.

PHP Code: 

Option Explicit

Sub GoToLastModifiedCell()
    Dim ws As Worksheet
    Dim lastModifiedCell As Range

    'Loop through all worksheets except the active one
    For Each ws In ThisWorkbook.Worksheets
        If ws.Name <> ActiveSheet.Name Then
            'Check if the worksheet has a last modified cell
            If ws.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious) Is Nothing Then
                'If not, go to the next worksheet
                GoTo NextSheet
            End If
            'If the worksheet has a last modified cell, check if it's the most recent
            If lastModifiedCell Is Nothing Then
                Set lastModifiedCell = ws.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
            ElseIf ws.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Modified > lastModifiedCell.Modified Then
                Set lastModifiedCell = ws.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
            End If
        End If
NextSheet:
    Next ws
    'Go to the last modified cell
    lastModifiedCell.Active
End Sub 


Kind Regards
Danny

Hi Trevor,

Last modified cell meaning the cell that was last changed within the work book (excluding any changes in the active worksheet, so basically visually the worksheet changes to the cell on another worksheet).

in principle that sounds like it would work, as it could sort through the worksheets and identify the most recent change (excluding the active worksheet) and then go to that next worksheet and cell.

would you know how to do this?

Kind Regards