using row and column in HYPERLINK?

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,388
I want to go to a cell (on the same sheet) using HYPERLINK but I won't have the column letter and row number but I will have the column number and row number.

Can those be used in the HYPERLINK function or do I have to convert them?

I found this:

=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")

but it's a bit cumbersome. Is there a more elegant way of doing it in the context of the HYPERLINK function? Please note that I don't have numbers for the column and row but I'll be calculating them from formulas that i'll need to insert into the function.
Thanks!
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,108,986
Messages
5,526,065
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top