cell names

  1. G

    Create cell name from contents of another cell

    I'm looking for a way to create cell names dynamically. I can find more complex answers to more complex questions, but not this one. For example: I'm trying to name cell B1 based on the contents of cell A1. And so on: the name of each cell in column B is the contents of each cell immediately to...
    • Gatito
    • Thread
    • cell cell contents cell name cell names dynamic cell name
    • Replies: 5
    • Forum: Excel Questions
  2. S

    change 1000 cell names in VBA

    Hello, ive got 1000+ cells with names that all start with CCL (ie, CCL.EBITDA.2007, CCL.EBITDA.2008, CCL.EBITDA.2009, etc) i would like to replace CCL with RBA using VBA. ideas?
  3. S

    Conditional Formatting Automatically Converts to Fixed Cell Names

    (Excel 2013) I want to stop conditional formatting from converting references to make them fixed (adding $s to the referenced cell name). Example: I want to format A1 based on B1, A2 based on B2, C1 based on C2, ETC I FORMAT CELL A1: Condition(B1="Finished") / Format(Green Font) When I save...
  4. B

    How to add variables for Formula Names in VBA

    Good day, I consider myself an amateur to basic user of VBA but can learn quick. I have found many answers and help on this site and appreciate this site very much. I work in Excel 2010 on Windows 7 OS. </SPAN> My current project is the client that wants to have a message box come up when...
  5. S

    Function to Add Cells if name exists

    I am working on a VBA program and have several VBA projects that create cell names if the area exists. For example- I filter data from one sheet to another based on a category number. At the end of that data set I complete several Sum functions to sum the data above. The sum data cells are...

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