title: Return row address when specific cells are filled
body: <p>I have some code that will return the row address when any of the column C:C is filled.</p>
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      Dim c As Range
      For Each c In Target.Cells
          If Not Intersect(c, Range(&quot;C:C&quot;)) Is Nothing Then
          Application.EnableEvents = False
              Range(&quot;A&quot; &amp; c.Row).Value = c.Address
          
          End If
      Next c
  End Sub
  
  </code></pre>
  <p>How would I go about adding to this code so that it would only occur when adjacent C:D:E cells are filled in any order? So if a value was added in C5 then D5 and then E5 it would return 5:5 as the row address but only after all 3 of those cells have values, if only C5 and D5 were filled it wouldn't fire.</p>