hyperlink cell address

  1. MrDB4Excel

    Cell Address Hyperlink

    In one workbook, in cell P2, I am using the formula: =MIN($O$4:$O$622) and in an adjacent cell, Z2, in the same workbook I am using the formula: =CELL("address",INDEX(O:O,MATCH(MIN(O:O),O:O,0))). The result in Z2 gives the address of the minimum value within O4:O622. This cell address then shows...
  2. C

    Execution Delays in Deleting Defined Names and Establishing Hyperlinks in VBA

    Hi All, I'm baffled regarding a peculiar delay when I run an excel VBA macro on a file with some 90 worksheets. The VBA code of interest is embedded with the worksheet itself (not a module). The worksheet having the VBA code is an "Index" sheet that will be populated with hyperlinks to the...
  3. L

    hyperlink address offset to select

    Can anyone help with this; I download a set of data which has hyperlinks which are not correct. I have a macro that changes the address of each link. While inside the loop I need to go to the new hyperlink address and capture some data from the url then past it in a range of cells addressed from...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top