hi,

I have different hyperlink of different cell ranges one first sheet, from F24:K24, until row F43:K43, a total of 20 rows (or 20 hyperlink)

Below is the long-winded code that I have written (i included 5 rows/hyperlinks only), which works for me. However, I believe there should be a short and better way of writting the codes.

Please Login or Register  to view this content.
Above is the cell link of my drop down list which indicates the row of the selection.

Appreciate anyone to help me to reconstruct the code in a better, compact flow.

Thank you very much.

Please Login or Register  to view this content.