Can't get a hyperlink to the first empty cell in a column of non-numeric values

Hello all,

I have been trying to create a link in cell A5 that will take me to either the first empty cell in a non-numeric column (H) or the last entry in that column. The column consists of a repetition of five categories (such as admin and literature research) in a fairly random sequence. As its an ever-growing list, the last entry will keep on going down, so I cannot simply link to cell H51.

I have tried several formulae in Excel2013, but this one came the closest to functioning:

Please Login or Register  to view this content.

With closest to functioning, I mean that it worked until I changed the first column identifier $H$ from a B to an H. It stopped working, so I changed it back and then it all fell apart.

I have a feeling that I've already touched upon the right answer along the way, but I haven't been able to make it work. Any thoughts?

I changed the ; to , for my regional settings... and fixed the filename info and it's working as described AFTER I CHANGED THE CELL FORMAT back to GENERAL, then reconfirmed the formula.

=HYPERLINK("[Sample logbook.xlsx]Activities!$H$"&MATCH(CHAR(255),H:H,1)+1,"Last entry")