Hi, I am using the code below to start a different Sub when the value of cell A1 in the active sheet is changed. However, the code is not working, meaning nothing is happening. The sub that is supposed to be started when the value is changed is working fine when run directly. I can't find my mistake in the code, but it must be something?
VBA Code:
Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Call CopyAndAppendRange
End If
End Sub