title: Finding Active cell's column header name using VBA in excel
body: <p>I have a table created from List of data. How to find the header text of each column</p>
  
  <p><img src="https://i.stack.imgur.com/PCDYu.jpg" alt="Table"></p>
  
  <p>When I select the activecell's header is high lighted to orange but I want to retrieve that value using visual basic.
   I am able to find excel sheet's address but I need table's column header</p>
  
  <pre><code>   Private Sub Worksheet_Change(ByVal Target As Excel.Range)
        MsgBox Target.Value 
        MsgBox ActiveCell.Address
     End Sub
  </code></pre>