Skip Blanks

Hi

I have set up a dynamic named range.

I need this range to be added to a userform but within the middle of this range are blank rows which need to exist.

In the dropdown I need to add to the vba code to ignore blanks.

My code so far is

Please Login or Register  to view this content.

Hope someone can help.

HI

Perhaps you could try something like this

Please Login or Register  to view this content.

Regards

Jeff

Thanks Jeff,

So Simple !!