Hi,
If anyone can assist with this query, I'd be extremely grateful. I have a 2-worksheet Excel 2000 workbook. I have a macro, "CalcSumMacro", that works fine when assigned to a button but I want the macro to run when I change the value of cell L7 (on sheet 2).
Under sheet 2, my code is shown below:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "L$7" Then Application.Run "CalcSumMacro()"
End Sub
I am not getting any compile errors. Can anyone advise why this isn't working please? Thanks in advance.
Cheers
Haydn
If anyone can assist with this query, I'd be extremely grateful. I have a 2-worksheet Excel 2000 workbook. I have a macro, "CalcSumMacro", that works fine when assigned to a button but I want the macro to run when I change the value of cell L7 (on sheet 2).
Under sheet 2, my code is shown below:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "L$7" Then Application.Run "CalcSumMacro()"
End Sub
I am not getting any compile errors. Can anyone advise why this isn't working please? Thanks in advance.
Cheers
Haydn