How to Hyperlink to the First Empty Cell in an Excel Column Range

It’s easy to hyperlink to a cell, or even a named cell/range. It’s even easy to get the first empty cell in column range (a range of cells in a column). But hyperlinking to that cell is a bit of a process. The following command though makes it super easy!

Summary of Behavior

If the column range is empty, goes to the first cell in the range If the column range is full, goes to the last cell in the range Otherwise, goes to t...