How to use this loop ?

[vumian]

Dear all,

Please open my file, enable macro, then Ctrl D to run it

i wanna check what items in DRP sheet, that does not exist in LoadingPlan sheet, If it's not, then msgbox "shortage this item"

it's rough here, and there is some blank cells at columns E

Do While Sheet1.Cells(i, 5) <> what

How to loop to end of last row including blank cells inside range

Thanks in advance