Posts by mpparker

Thanks again Carim, working now!

Thanks Carim, can you give me a quick example on how i would write this in a standard module.

Sorry I'm struggling with this one!

Regards
Martin

Hi All

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

Regards
Martin