Problem with userform code

I have created this userform bymyself with a lit of help from internet articles.
the task is when i run the module it pops up the userform.i am selectin an area that i like(in this sheet the range("b2:f14") and when i press the command button with the caption BLANK CELLS it gives me an error
Where is my mistake in the code?
Thank you in advance

Could you not just use evaluate?

Please Login or Register  to view this content.

Originally Posted by KOKOSEK

Remove minus 1 from here:

Please Login or Register  to view this content.

and BTW so far You have count NO empty cells and display as XX empty cells.

thank you very much for your answer.the code now is not giving me an error but is giving me wrong results.
when you say i don't count empty cells but xx empty cells what do you mean?

Originally Posted by ByteMarks

Could you not just use evaluate?

Please Login or Register  to view this content.

thank you very much my friend .this code worked perfectly

Originally Posted by KOKOSEK

I mean, you count NOT EMPTY CELLS

Formula:

Please Login or Register  to view this content.

and display message about counted EMPTY CELLS.

Ι understant now what you say.thank you very much