Searching trough RANGE for any VALUE and excluding specific VALUE from results

[GOR4N]

I'm trying to search trough a RANGE for cells that contain some data. When data is found, I need to print the corresponding name with found data. Data can be located in two columns for the same name but I don't want to print name twice ... instead I need one name and all cells with data which belong to that name.

Also I don't want to include TABLE HEADER in search or let's say to skip cells containing specific text.

I have made a macro named FindNext_Example and I need some tutoring to complete this task.

Quick illustration of my table:

Name1	10 days
Name2		+10	1 week
Name3	7 days		3 weeks

I would like to get Debug.Print

Please Login or Register  to view this content.

Excell file with complete table and macro is attached, and also I wrote some comments in code to make it easier what are my problems.

[xladept]

Try this:

Please Login or Register  to view this content.

[GOR4N]

Try this:

I've made one tiny correction because TOTAL was printing as a result (obviously because my comment was TOTAL only without ":" )
So it now looks like this and it's working

Please Login or Register  to view this content.

Because this is beyond my VBA knowledge is it too much to ask You explain me this SELECT CASE thing?

[xladept]

The select case is sort of like an If....Elseif.....Elseif statement but it can be used for many instances (usually three or more) - it checks the value of the designated field and acts accordingly. As you can see, it's being used with an If...Else statement here.

Please Login or Register  to view this content.

For a hit in column E a value of "INJURY" makes it skip to another candidate, otherwise it augments the string sets the found range to Column F and repeats.

[jindon]

I would like to get Debug.Print

Please Login or Register  to view this content.

Please Login or Register  to view this content.