Message box

[jaycee]

I have a loop that checks column L for values of greater than 9, this then adds a message box to say this, what I need is the value in the corresponding row column "B" value to show in the message box.

IE L11 is 12 then messsage box should have the value for B11

 

[slinky]

You could add in an if ISEMPTY statement to handle those.

Have a look here -> MS Excel: ISEMPTY Function (VBA)