defined name

  1. L

    (Excel) Define several incremental cells' names at once

    Good morning folks! I am trying to rename a row of cells with incremental names. Ex. A1=Results1, A2=Results2, A3=Results3, ...., AN=ResultsN Of course, it can be done by setting names for each cell separately but it takes ages. I would like to know if this is possible to do that quickly...
  2. T

    conditional format where formula uses a defined name

    I've researched through the forums and haven't found a specific answer, so my apologies in advance if I just didn't look hard enough. I want to highlight cells that contain formulas that reference a specific defined name. The purpose is to show where that define is being used, and where it's...
  3. H

    define names using COUNTA

    Hey guys, first of all thanks for the support during the whole time, i used this forum quite regularly I finally signed up because I cannot figure out how to solve a (hopefully) minor problem. I am using VBA to automatically create a bunch of defined names on a help! sheet in order to...
  4. W

    Dynamic Range in Xcelsius

    I am working in Xcelsius 2008 and I have created about 100 defined names. These refer to cells on Sheet2 that create ranges. I am having an issue calling the range as it gets returned as text. E.G.: I am using the following to build a range based on where the column header is found...
    • WWWINC
    • Thread
    • defined name no indirect string to range xcelsius
    • Replies: 0
    • 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