Testing For A Blank Cell

I have the following code so far. Im not confident that the syntax is correct as Its been some time since i've used VB I can only remember C# these days.

Please Login or Register  to view this content.

What I am looking to do is test if the changed cell is within the range I11:I110 and if so check the contents in column L of the corresponding row to see if it is blank. The reason for this is that I need to have an error log on my spreadsheet to show that something has not been completed correctly. This is stored in cell D3 which will be a value showing how many errors there are.