Need Help Modifying Code

[ayvee0]

The code below was provided to me by a user on the forum. It takes inputs from columns and creates combinations of them (I've also attached the file).

It uses the .CurrentRegion function - however, I'm missing information in column B, so if I start in column A, it'll ignore C and D.

How would I modify the code such that it ignores the column with missing information and skips directly to the next column?

Thank you!!

Please Login or Register  to view this content.

Chinese Menu.xlsm

[ayvee0]

if you have a different code that would be okay too!