![]() That is *weird*! The syntax does not feel like Excel. You want to jump to the sheet called IncomeStatementĬ:\FolderName\FileName.xlsx#'IncomeStatement'!Z99 Selina's question, though, is how to have Excel jump to a specific sheet and location. Press Ctrl V to paste the results of #5 above.Īt this point, the hyperlink would simply open the Excel file to the last active sheet and cell. ![]() Press Ctrl K to open the Hyperlink dialog. Select where you want the hyperlink to appear. Select the resulting line and press Ctrl C to copy to the clipboard.On the next line, you will see the full path and file name.Type Debug.Print ThisWorkbook.FullName and press Enter.Press Ctrl G to open the Immediate pane.Well, it may not work like you want it to work, but it nominally works.įirst, figure out the full path
0 Comments
Leave a Reply. |