Excel macro cell address increase
<p>Can i increase the cell address by using macro?
I'm implementing excel cell color matching function.</p>

<p>Example:
When i change the cell "A1" to red, cell "D1" will change to red.
if change "C1" to red, "F1" will change to red too. All need to increase 3 column.</p>

<p>Now i just need to modify the "c.Address" by + 3 so the cell will go do D1.
I try using c.Address + 3 but it can't work.
Any help will be appreciate!</p>

<p>Thanks!</p>

<pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)

For Each c In Worksheets("Sheet1").Range("A1:C1").Cells

    If c.Interior.Color = 255 Then
    Sheet1.Range(c.Address + 3 ).Interior.Color = 255  &lt;&lt;-- Can't work

    Else
    Sheet1.Range(c.Address + 3 ).Interior.Color = white &lt;&lt;-- Can't work

    End If

Next c

End Sub
</code></pre>