cell name

  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...
  2. C

    Problem with tab names equaling cell name.

    I found a code to make the tab name equal a cell in the worksheet: Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String =...
  3. K

    Adding to an existing macro to make Excel rename sheet after specific cell.

    Hello, hope everyone is doing OK. I have been using Microsoft office products for years now. I've only recently discovered however, macros and some of the other "behind the scene" tools available. What I could use a hand with is this; with the help of my son, I have recoded a macro that records...
  4. R

    Please, How Can I add data by cell [name box] name?

    I would like to added some named cells on my weekly work log. Every week I name the total hours on a job: EX: "Frame1", the next week "Frame2", etc. This is in a sheet with other jobs. So, I tried: =sumif(Picked Range,"Frame*") But, this doesn't work.... I can add them individually...
  5. B

    range naming/ grouping

    Is it possible to do the following more easily. Sheet1 is a summary sheet that pulls basic information for each vendor from 8 different sheets. The 8 different sheets have the exact same layout and contain more detailed information. I need to be able to change the order of vendors on the...
  6. B

    textbox & cell name

    I would like to be able to have a userform define the name of a cell. The formula bar will be disabled/hidden along with being in full screen mode. This will help me from having to take a couple of extra steps in the future.
  7. H

    Batch cell names renaming

    I'm currently merging similar Excel workbooks in one file. And they use the same cell names. And i will need to reuse those values in another worksheet later. SO I need to rename a lot of cells and it would be really long doing it with the name manager, is there a faster way to do it? Also, i...
  8. T

    hello I am trying to define cells name by cells value I have tried activecell.name = activecell.value

    hello I am trying to define cells name by cells value I have tried activecell.name = activecell.value but I want more than one cell to define I am trying selection.cells.name = selection.cells.value I want every cell in selection sets it's name by it's value also i am trying to select a range...
  9. S

    Calling out a sheet from another workbook based on a cell value

    Hi All, I have this problem to get over. I need to call out a sheet based on the same name as a cell value which I would input. Basically it's for easier extraction of a particular worksheet from another workbook. For eg: Each sheet has a unique number associated to it (eg: 123). i want...

Watch MrExcel Video

This Week's Hot Topics

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
Top