ExcelBanter - Syntax to obtain the SubAddress of a Hyperlink in A1 on Sheet1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Syntax to obtain the SubAddress of a Hyperlink in A1 on Sheet1 (https://www.excelbanter.com/excel-discussion-misc-queries/121732-syntax-obtain-subaddress-hyperlink-a1-sheet1.html)

EagleOne

Syntax to obtain the SubAddress of a Hyperlink in A1 on Sheet1

[double post unintended]

2003

In addition, the best way to separate the Sheetname from the Cell
reference from that SubAddress.

Any thoughts appreciated!

TIA EagleOne

All times are GMT +1. The time now is 07:27 AM.