I am using the following code inserted into a worksheet_change event with no problem... all working as expected, however, as I am wanting to move the code highlighted in red into a standard module as I will be checking hundreds of cells and the code required exceeds the permitted size allowed. My question is... how do I write the 'if not intersect......' code in a standard module, as i need to refer the code to a specific worksheet, lets say 'Sheet1'
Any help/pointers would be very much appreciated.
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("d16")) Is Nothing Then msgbox "Hello!" End If End Sub