Thanks again Carim, working now!
Posts by mpparker
-
-
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)
End if
Regards
Martin