Hyperlinks and/or VBA Workaround

Hyperlinks and/or VBA Workaround

Hello,


I have some hyperlinks in an Excel document that refer to other locations in the same document.  I have figured out how to create a macro button using VBA that goes to another tab, but I am having difficulty creating a macro button that will simply scroll down "X" number of rows.  My understanding is that to do this in Excel, one uses the GoTo function, which is not supported in Zoho.  Is there a workaround for this?  I have tried the following

  • Application.GoTo Sheets("Sheet2").Range("A100"), scroll:=True
This gives an unknown function GoTo error.
  • Sheets("Sheetname").Range("A100").Activate
This selects the cell that I want to display, but does not move the displayed cells (so A100 is selected but offscreen)



Any other suggestions?