Hello,

I have a Public Sub that sorts a range of cells in alphabetical order on Worksheet 1. When I execute this sub manually, it works. However, I would like it to automatically execute when a cell value is changed on Worksheet 2, within the same Workbook. Both the Worksheet_Change Event and Public Sub are written in Worksheet 2 where the Change event takes place. Can someone please explain why the sub does not execute when using the following code?

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("Date_Cell")) Is Nothing Then
    Application.EnableEvents = Flase
        Run "Range_Sort"
    Application.EnableEvents = True
End If

End Sub
Many thanks!