Actually I have just thought if it wouldn't be easier and simpler to have the macro just checking range in A and for the same amount of cells with data, the same amount of cells in column B should have a numeric value bigger than 0.

By bigger I mean 0.001 is bigger as there are some products that can go as far as 0.050Kg.

If the number of cells in column B is not equal to the number of cells in A then return error such "You have selected items with zero quantity. Please check your invoice." set focus to the very first empty cell and that is it. I would be happy with this.

I believe this would make it much simpler no?

The only thing is it must see identical cell in line to each other. Example considering that there is an invoice of only 1 item;

A10=butter basted

B11=1

Now this is the same number of cells with data right? There is one cell in A and one cell in B. But the macro must see this as wrong as for A10 there should be a numeric value for B10.

I hope I am not making this way confusing and if this last approach of mine makes it any easier I would go for it.

Many thanks.

Cheers.
Albert