cell "address"

  1. k3yn0t3

    How to update Indirect formula so that cell reference is based on a hardcoded cell value?

    Hi all. Quick question: Does anyone know how to update the formula in I22 to make it be fed by the cell reference i hardcoded into A19? I tried replacing the H60 in the Indirect formula with "text(A19))" but that doesn't work. The reason I would like to do this is so that I can copy and...
  2. I

    A button to make selected cell and copy several columns below it..

    I wont to make a button (1),That have function copy several column (2), form selected cell (3). To other worksheet which already prepared (4)
  3. T

    Cell address issue

    Hi, can someone please help me with the below formula, I am after just the cell reference but the result also brings through the name of the workbook and worksheet, any help would be great =CELL("address",INDEX(INDIRECT("'" &$A2&"'!f2:z10"),MATCH($C2,INDIRECT("'" & $A2 &...
  4. K

    locale of info_type argument of CELL function

    Hello! I would like to modify CELL function that is using info_type argument to work independently of Excel or Windows locale settings. The problem is that I am using Excel with SK locale setting: CELL("adresa"; ...) which will not work when opened in Excel using other locale settings, e.g...
  5. Z

    hyperlink formula using CELL("address"...)

    Hello. I've had a lot of luck using the hyperlink formula but am stumped by this one. Here's the path to the workbook: C:\Users\MyName\Documents\ExcelFolder\MyWorkbook.xlsb > MySheet > MyTbl and in column D of MyTbl is the field TVSeries. In cell D17 is "Atlanta" without quotes. I'm trying to...
    • zaquin
    • Thread
    • cell "address" formula hyperlink hyperlink formula link_location
    • Replies: 6
    • Forum: Excel Questions

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