The post by Admin is meant for the worksheet change event to be triggered, and then the kTest procedure to be run. If you want to limit the trigger to a change in column V only, you could use
Code:Private Sub Worksheet_Change(ByVal Target As Range) if Not Application.Intersection(target, Me.Range("V:V")) Is Nothing Then kTest End If End Sub




Reply With Quote

Bookmarks