to exit main procedure from procedure called by yhe main

[kmlprtsngh]

Hi all,
i am using a code that loops through a range and finds if any cell is empty.On finding one i use msgbox as-"The cell is empty".
However I want to display the cell which is empty in msgbox.

code used is shown:-

Please Login or Register  to view this content.

any help will be appreciated.

[Andy Pope]

Try this which uses the specialcells method rather than looping.

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[kmlprtsngh]

Thanks andy the code worked perfect