Run/call a macro when value in cell A5 changes
I'm glad I could help and even more so from the pleasure it seems to give you
:)
"Arno" wrote:
Mike,
I have no words to thank you ! I worked staight away !!!
This was the last step of a difficult xls file with about 20 macros. Now
everything work ! Thank you so much again!!!!!!
Thank to you Dave as well !!!!!!
"Arno" wrote:
Hello,
I need a macro to run/call another macro when values in cell A5 changes.
Can you please advise if the syntax below is correct.
So far I cannot get it to work ....
Thank you !! Arno
Sub Last()
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$5" Then
Graph2
End If
End Sub
|