name cell

  1. B

    Formula to create named cell

    I have a database export of item prices i want to import into another estimating program. This program requires the item prices to be in a named cell. I have a unique name in column A and want to create a named cell in column D with that name. Problem is i have 3000 rows and dont want to go...
  2. M

    Challenging: VBA to Combine (1) Naming Ranges with Another Range's Values; (2) Row & Column Loops; (Finding Last Row/Column)

    I have a lot of ranges I need to name. I want to use VBA to name every range in a column by referencing another column that contains the range names to be used. For instance, I want to name cell E3 (which has a value of 1) with the name in cell A3 (JillJan). Then, name cell E4 (which has a...
  3. D

    Macro to copy template, named based on cell value in order & allowing data to be added to original list

    Hi there, I'm a complete newbie at VBA, only looked at my first code this week! After searching many forums (thanks for your help everyone!) I have modified code to work somewhat. My macro currently copies a template and renames it based on data on my "estimate" sheet, what I need help with...
  4. D

    Add Names to Multiple Cells using Array

    I'd like to define names for 52 cells and do it with one array. I recorded the naming of one range and learned the .Names.Add Name:= notation so I'm wondering can that be combined with an array. I'm getting a 438 object error when I try the following - any ideas? Sub TestNameArray() With...
  5. T

    Looping through range names [VBA]

    Context: Medium skill VBA user - Old poster that lost it's previous email Hi, I’ve been coming across a VBA question that would simplify my codes and I can’t find the answer. Maybe you can help me out: Let’s say that I have three ranges that I have name in Excel: ARoot BRoot and CRoot. I...
  6. V

    Create Copy of template using macro and Name them as per list

    Hi, Having a tough time creating excel files with names mentioned in a list(150 +) every month. Sure someone has an answer to help me here. Here is the scenario: I have a macro enabled workbook "Database" which collates data from several file kept in the source folder and then format the same...
  7. H

    Variable-sized NAMEd range

    I have a column-vector that starts at a fixed row (NOT Row 1) and continues down to the last-used cell in that column. The number of used rows varies from time to time, getting either bigger or smaller according to needs. I have defined a Name for that vector and the name is used in several...
  8. O

    VBA to find Value, then Name Cell

    I want my code to do two things. 1) Locate the cells in Column A that have a certain value 2) Name the cells with that certain value All the values will be in Column A. The word I am searching for will appear three different times in the column. I need a code that will find those cells and name...
  9. P

    Referencing named cells from other rows in formulae

    Hi, everyone - new member with a first post. I am trying to solve a problem which doesn't really exist (story of my life!), but I like neatness in my Excel formulae and figure that there should be an easy way to achieve my objective in this instance. I have created a spreadsheet to document...
  10. H

    Full name

    Column B & column C contains NAMES. But they can be different in the sense either of the column may contain more no. of words which are only separated by 'a blank'. How to get the larger NAME? EX: Column B=PETER SHIRT Column C=PETER ENGLAND SHIRT Answer is Column D=PETER ENGLAND SHIRT
  11. 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...
  12. B

    Name Cells???

    Does anyone know if it is possible to have two cells/Ranges named the same thing in one Workbook (Two different Sheets)? If so how might I accomplish that. I want Cell "D1" on Sheet1 to be named "Test" and Cell "T17" on Sheet2 to be named "Test" as well. this doesn't have to be done in VBA...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
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 "".
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