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
Bookmarks