Hyperlink to bottom cell of table

[Smally]

Hello. I'm trying to create an intro page that has hyperlinks for each of my sheets. On one of my sheets is a table (called tblSOS). I'd like a hyperlink to select the bottom cell in Column1.

Is this possible?

[DBY]

Hello
Maybe the Hyperlink function. For example:

Please Login or Register  to view this content.

Here the table is on Sheet2 assuming Column A.

DBY

[Smally]

Great thanks. I never knew there was a hyperlink function.

Your formula would select the second to last row, I'm guessing because on Row 1 I've reserved to display the title and explanation of the sheet, so I just stuck +1 near the end of the formula

[DBY]

Glad to have helped. I forgot to mention that you can also add a friendly name to the hyperlink to be more specific as to its target:

Please Login or Register  to view this content.

Regards
DBY