Type Mismatch

Hello

After Long time i need a help from you

I created a code to generate the Userform when the particular columns value is reach to 0, the code is working fine but there is small problem that is Type Mismatch error. When The error throws to me if i delete a multi rows and Columns data then the error report is displaying. the code details is given below

Please Login or Register  to view this content.

if i delete any single cell then there is no problem

kindly help me about this problem

Thanking You

Patnaik

@Norie

Hi

Thanks for your support the code works like a charm and thanks for advise for the UserForm1.TextBox1.SetFocus

With Regards

Patnaik