How do I reference the cell value within a formula string

0 votes

To a cell in the worksheet, I'm attempting to establish a dynamic hyperlink. Dynamic means that instead of going to a specific worksheet in the workbook, the hyperlink will always go to the cell on the active sheet.

I was able to find the formula for a dynamic HYPERLINK for referencing the active sheet:

cell hyperlink =HYPERLINK("#D116",B37)

Now, I'm attempting to ensure that not just the connection remains dynamic, but also the reference cell. I want the cell number to update automatically whenever I add or remove rows. I reasoned that I couldn't do it using the original HYPERLINK function because the cell number is enclosed in quotation marks. I am therefore attempting to determine how to include the formula from Column C in the HYPERLINK function.

the value I need to incorporate in the HYPERLINK function =CHAR(34)&"#D"&ROW($A$116)&CHAR(34)

=HYPERLINK("&C37&",B37) does not work.

Is it possible? If not, is there another way of doing so? VBA, perhaps?

Feb 24, 2023 in Others by Kithuzzz
• 38,010 points
493 views

1 answer to this question.

0 votes

Try:

=HYPERLINK("#"&CELL("address",D116),B37)
answered Feb 24, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

answered Nov 7, 2022 in Others by narikkadan
• 63,420 points
848 views
0 votes
1 answer

Excel-How can I get the address of a cell instead of a value?

There are various difficulties in this. Which ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
• 63,420 points
236 views
0 votes
1 answer

How do I get it to select a single row based on the value?

Try this: Sub MoveBasedOnValue2() Dim ...READ MORE

answered Jan 20, 2023 in Others by narikkadan
• 63,420 points
332 views
0 votes
1 answer
0 votes
1 answer

ActiveSheet.Hyperlinks.Add don't show Text To Display

Here's how Excel functions. Not a bug, ...READ MORE

answered Mar 26, 2023 in Others by Kithuzzz
• 38,010 points
278 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
838 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,090 points
788 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,090 points
4,023 views
0 votes
1 answer

In excel how do I reference the current row but a specific column?

Put a $ symbol in front of ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 63,420 points
1,242 views
0 votes
1 answer

How do I align a UserForm next to the active cell?

Answer to Q1 - Yes, it's correct. In ...READ MORE

answered Oct 27, 2022 in Others by narikkadan
• 63,420 points
876 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP