msgbox: Argument not optional

Hi,

I want a msgbox to appear if there are blank cells in a range,
the code below is nearly there, however with teh msgbox I receive:
'Compile Error: Argument not optional'.
Many thanks in advance

Please Login or Register  to view this content.

End Sub