Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Frame Analysis with Excel - 3, Continuous beam or frame
- Writing Arrays to the worksheet - VBA function
- 3DFrame - 3D Frame analysis for Excel
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