For each loop not working

**schzuki** · 03-31-2014, 08:58 AM

Hi guys,

The code that I am working on is giving me some trouble:

I have a list of text values with intermittent empty values:

text1
text2
(empty)
text3
(empty)
(empty)
text4

I want my code to perform a number of actions for each text# in the range. I am using a for each loop:

Please Login or Register  to view this content.

The code works fine, but there is 1 problem: I want the loop to skip the empty values in the textlist. I tried adding the following code:

Please Login or Register  to view this content.

But this keeps asking to add a value behind the For statement.

I have been looking for solutions for several hours, but I cannot find a solution. Do you guys have any suggestions?

BTW: the list range gets its values from another sheet using a simple = sheet1'!A1 statement.

All help is appreciated!

Thanks!

Schzuki

**sktneer** · 03-31-2014, 09:07 AM

First of all congratulation. Netherlands beat England today in T20 World cup 2014 by 45 runs.

Now your problem.....

I think the code should be like this.....

Please Login or Register  to view this content.

See if this helps.

**schzuki** · 03-31-2014, 09:43 AM

Go dutchies! That makes it 1 out 4 doesn't it? (we will get there eventually)

Your solution worked perfectly! A simple solution to a vague problem, I like it...

Thanks so much for your help!

Schzuki

**sktneer** · 03-31-2014, 09:54 AM

Glad to help you. Thanks for the feedback.

If that takes care of your question, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.