move to next row repeat process vba
<p>I have a worksheet with column A listing a series of risks.</p>

<p>Column F lists items that can mitigate these risks.
I want to write a script to identify if the risks in a have a control or do not have a control
for example</p>

<pre><code>A                  F
Risk7              control
                   monitor
                   test
Risk8              (blank)
</code></pre>

<p>so output would be 1 risk with a control and one risk without</p>

<p>my script so far is</p>

<pre><code>Sub CountWithWithoutControls()

' counts number of risks with controls and without controls, 
' currently running through each cell and comparing back to original control, 
' need to write to get it to walk down the series

 Dim cell As Range
 Dim myrange As Range
 Dim control As Long
 Dim WoControl As Long

 Set myrange = Range("a7:f27")

 For Each cell In myrange     
     If Range("c7") &lt;&gt; "" And Range("f7") = "Control" Then control = control + 1
     If Range("c7") &lt;&gt; "" And Range("f7") &lt;&gt; "Control" Then WoControl = WoControl + 1     
 Next cell

 MsgBox control &amp; "  = number of risks with controls" &amp; WoControl &amp; ("  = number of risks without controls")

 End Sub
</code></pre>

<p>I'm new to VBA and while I don't think this should be that hard I'm not making any progress.  any hints in the right direction would be most appreciated!
thank you all
Paul</p>