Adapting VBA Code to Exit Loop on encountered blank cell (Data Validation List)

[Mitchx]

Hello Guys,

I am using the code below to iterate through a data validation list, however in the data validation list there are a lot of blanks.
I wish to stop the loop when a blank row is encountered.

The code works perfect, but it keeps looping until infinity.
Does anyone have an idea what to add to stop the "next c" part when a blank value is encountered in the data validation list (so the InputRange)

Thanks in advance!

 

[GWteB]

Hi Mitchx, welcome to Mr.Excel.

I would like to ask you to post your code using code tags instead of an image.

Then the volunteer helpers of this forum don't have to manually type your code all the way through to try things out.
Please take a look over here ...

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

 

[Joe4]

Welcome to the Board!

After this line:

For Each c in inputRange

try adding this line:

If c.value= "" Then Exit For

Also note GWteB's note on posting VBA code here.
If you use that tool to post your code in the future, it will make it much easier for us to copy your code and help you.

 

[Mitchx]

Welcome to the Board!

After this line:

For Each c in inputRange

try adding this line:

If c.value= "" Then Exit For

Also note GWteB's note on posting VBA code here.
If you use that tool to post your code in the future, it will make it much easier for us to copy your code and help you.

Hey Joe,

You are a legend!

Thank you very much, it worked.
I have tried something like your solution, but I must have made a mistake somewhere.

Again thank you

 

[Mitchx]

Hi Mitchx, welcome to Mr.Excel.

I would like to ask you to post your code using code tags instead of an image.

View attachment 49410


Then the volunteer helpers of this forum don't have to manually type your code all the way through to try things out.
Please take a look over here ...

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

Hi GWteB,

I am sorry, I will do that for future reference!

 

[Joe4]

You are welcome.
Glad we were able to help!