For loop

Hello peeps. Virgin poster here

So look my problem is that I'm pretty
Noob and I can't seem to write a for loop
That meets the correct syntax requirements for VBA

what I want is a piece of code that will
Verify that if any cell in range c8:c16
Contains "yes". Then I want to To Refer to
Store the corresponding description(s) which are in the a8:a16 range


Much like the vloOkup function
However I need to process this data further so I cant use
Vlookup. there will also be various instances of 'yes' and
Various descriptions of the corresponding entities further impeding 'vlookup'


This resembles something that I tried. It was put as function initialising on a button click event and it didn't work;

Dim array1() as variant
For I = 0 to 7
If sheet1.range("c" & I).text = "yes" then
Array1(I) = sheet1.range("a" & I).text
End If
Next

And I'll be referring to the array(n) in a separate function
That emails a list of people describing what's in cell a
And a8,a9, etc .. If the corresponding c8,c9 contains 'yes'

The ("c" & I) is an attempted concatenation
Of c and the stepping variable I.e c8,c9, etc

HI Kazinstsky,

welcome to the forum.
Suggest you to change the thread title to reflect the query you are asking, also use code tags for your code, see forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey
<click on below * if this helps>