Thanks for the VBAVLOOKUP!!!

This helped out a bunch! Thank you very much! :D

Thanks Dan. Great examples

Thanks Daniel. Good tips.

Thank you so much!! 👍👍

Thanks for that - I actually did use on error resume next but I put it in the wrong place so you saved me a ton of time

Thanks a bunch ! ! !

Thanks a lot.

great explaination broo you nailed it ... thanks it helped me a lot

Very good Thank you

Thanks a lot

Why is Option Explicit not being used variables with type being declared? And use Application.VLookup so if not found you capture the error value in the variable declared as variant. Then you simply test If IsErrorI(myVar)......

I don't know why but even tough I do the same exercise error handling is not working, I double checked the code but nothing happened, any suggestion?

sir i am trying ro make a userform in which we can make invoice of multiple items even we have set invoice to just 10 items and after 10 items there is total column where we have added a sum formula.suppose we 40 items to bill now userform should count items and add blank rows and fill rest of items after 10 items invoice template. you have given instruction how to make a userform and invoice with userform but i need your instruction how to make a dyanmic userform where we can make multiple of multiple items invoice via userform and after we can reset our invoice to default stage too. please guide me? it can help lot of other people too. Show less

First