title: VBA Add Anchor (Hyperlink) to Active Sheet
body: <p>I'm trying to create a hyperlink from the active sheet to Sheet1. Everything works great except for the "Address" in the anchor tab. I'm not sure if I have the correct syntax for connecting the active sheet to sheet1. The active sheet will always have a different name each time, hence the reason for needing the syntax for the active sheet as apposed to giving it a specific name. </p>
  
  <p>Set rng = Sheets("Sheet1").Range("A50").End(xlUp).Offset(1, 0)
  rng.Hyperlinks.Add anchor:=rng, Address:=ThisWorkbook.ActiveSheet, TextToDisplay:=UserForm2.TextBox4.Value</p>