title: VBA - Excel create a hyperlink using the sheets command and cells method
body: <p>Q1: The routine below does not work.</p>
  
  <pre><code>Sub test()
  TXT = Sheets("INDEX").Cells(2, 1).Value
  AKO = Sheets("TOBESEEN").Cells(1, 1).Address
  Sheets("INDEX").Hyperlinks.Add Anchor:=Sheets("INDEX").Cells(1, 2), Address:="",
  SubAddress:=AKO, TextToDisplay:=TXT
  End Sub
  </code></pre>
  
  <p>Q2. Is there a place where I can see ALL the properties of the cell? When I type the "dot" after cells, VBA DOES NOT GIVE any options.</p>
  
  <p>Like</p>
  
  <pre><code>sheet1.cell(1,2).VALUE
  sheet1.cell(1,2).ADDRESS
  sheet1.cell(1,2).?
  </code></pre>
  
  <p>I suspect my problem is related to the definition of AKO, but I am not sure what the correct property is (if not ADDRESS)</p>
  
  <p>Thank you</p>