Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads
- Writing Arrays to the worksheet - VBA function
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Contour plots with Excel and Matplotlib
- About Newton Excel Bach
- Latex Maths Text in Excel
- Converting from global to local coordinates (and vice versa)
- Installing Python and pyxll from scratch
Recent Comments
Tag Archives: hyperlinks
Using Hyperlinks
Hyperlinks are useful to link to other locations in a spreadsheet, or any location with an accessible address, but they can do more than that. A recent post at Daily Dose of Excel looks at using hyperlinks as a general … Continue reading
Extracting a hyperlink
Excel does not have a function to extract the address from a cell containing a hyperlink. Here is a short UDF that will do the job: The original was a one-liner posted by Rick Rosthstein on Debra Dalgleish’s Contextures Blog. I … Continue reading