Object variable or with block variable not set error in VBA

[Shanthan]

I have two worksheets, which are Sheet1 and Edit Log. I like to go from Sheet1 to Edit Log and enter some information in the last row in Edit Log. But, I am getting Object variable or with block variable not set runtime error.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

    ' Other code here to be executed in Sheet1

    Dim LastRow As Range
    Sheets("Edit Log").Activate
    Set LastRow = Sheets("Edit Log").Cell(Rows.Count, "A").End(xlUp).Row
    Sheets("Edit Log").Range("A" & LastRow + 1).Value = Format(Now, "dd/mmm/yyyy @ hh:mm:ss AM/PM")
    Sheets("LastSheet").Activate       'Takes me back to Sheet1 after the information is entered in Edit Log.
    
    End If
End Sub

Where am I doing wrong?

[Yraen]

You've got LastRow as a Range but are returning a row number to it which is a Long.

[Shanthan]

Thanks for the reply. I was getting Compile error: Object Required when I changed LastRow As Long. But, it worked when I set LastRow as Integer. I don't know why? Any ideas?

[Yraen]

It's probably the set, it's not needed.