Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Installing C# dll files, reminder
- Continuous beam analysis with cubic splines
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