Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- The history of the theory of beam bending - Part 1
- Downloads
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- Daily Download 4: Continuous Beam Analysis
- Filling Blanks with Go To-Special (and local help rant)
- The Conjugate Beam Method
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