named range

  1. R

    Why can't I use named range 'R3PM' ?

    Hi experts! In our company we have a program called 'R3PM' and we want to use it as a named range. But we get the error: "The syntax of this name isn't correct." Why do we get this error? Is it because letter 'R' is reserved and after it comes a number (3)? Thanks for the answers! Roy
  2. Johnny Thunder

    VBA Help - Ungrouping Named Range Columns based on Variable

    Hello All, I am working on a project that will Group/Ungroup specific columns based on a loop. for ease of maintenance I have created Named Ranges for the groupings to Expand or collapse the groupings based on a variable in a list. Here is the list Excel WorkbookABC1DivisionsNamed...
  3. P

    Name range to have a variable section linked to a cell

    Hello everyone, Does anyone know if you can create a variable part in your named range. I don't want a dynamic named range I want to literally change the named range. So imagine you have a named range : IncomeStatement.17.18.AfterBoardAdj I want the 17.18 to change to 18.19 by linking it to...
  4. G

    Refer to named range using variables

    Hi, I'm trying to copy a named range without having to have the name of the range hard coded but having difficulty getting this to work, attempt below but it's not working as I expected it to: This is at the top of the Module as I'm using a UserForm to define the variable site_name: Public...
  5. pliskers

    Removed Records: Named range from /xl/workbook.bin part (Workbook)

    I know there have been numerous posts about this error message, but none of the fixes has applied to me. I'm exporting to Excel from an Access table, and when I open it I get an error message prompting if I want to recover as much as possible. When I do, I see: Removed Records: Named range...
  6. K

    Conditional formatting look up into a table/named range

    Hello :) Please could someone help me write a formula, that looks up between workbook1 and named ranges/tables on workbook2. In book1 I have a "Role" column (D) and then a "Name" column (E). In book2 I have named ranges (also made into tables) that are headed with a variety of roles. One of...
  7. H

    Non-Contiguous COUNTIF range

    Hello All, I am struggling to find a way to COUNTIF the rows label 'Qty' are less than a value. I have tried naming the range but COUNTIF doesn't seem to work on a named range. Ultimately I would like formulas to for Qty < 30, Qty < 40, etc. I would do the same with time (formatted in m:ss)...
  8. zakasnak

    VBA error 1004 Formula is missing a range or a defined name

    Good Morning! I have vba that purges data for public posting, then saves each tab (named range) as a separate pdf to combine & post to the web. I'm getting a Run-time error '1004' "This formula is missing a range or a defined name" on Named Range(Table_7), on Tab "Table 7", when trying to save...
  9. D

    Hidden/Un-locatable Named Ranges/Charts

    I have been provided a worksheet which I am expanding upon. When I selected the first tab of the sheet yo copy as a template for a new tab I get the below message.. "The name '_1_123Graph_ACHART_9'already exists. Click Yes to use that version of the name, or click No to rename the version...
  10. B

    named range referenced in formula

    Hi, I have a sheet with data points and another reference sheet with the different ways to write different body parts. The idea is to see which body parts/ appear in each data row, but because there are multiple ways to say the same body part, I have put the different variations of body part...
  11. P

    Dynamic Ranges (without range address unavailable) inside a Formula

    Hey Guys! I immensely need your help for the below scenario. I am trying to find a way to address range in a formula. The problem is that, the range is created dynamically. Please refer below image further. Here I have 2 tables say Table 1 & Table 2, these tables are snippets of my actual...
  12. L

    Sumproduct, Countifs, Range help

    HI There, i require help trying to write a formula i have the first part working fine as per the below =SUMPRODUCT(COUNTIFS(INDIRECT("'"&SheetList&"'!AF:AF"),">"&TaskID!$A25,INDIRECT("'"&SheetList&"'!AF:AF"),"<"&TaskID!$B25)) TaskID A25= -1 TaskID B25= 8 I have 3 sheets and i have...
  13. D

    Show Data Validation Source in Cell

    Hi, I am trying to show the Data Validation Source in the cell which has displayed "Click here to view available values". Any help would be appreciated. Thank you in advance.
  14. Mary90

    Getting value from named range that was defined as a formula

    Good day guys! I'm trying to use a hidden named range to hold the value of a date that I can refer to in my VBA formulae. So I've created a named range called "ExpiryDate" and it does not refer to a cell, but directly to: "=DATE(2018,12,31)" So using vba, I'd expect...
  15. Z

    Resize all named ranges on a sheet with LastRow

    Hi All, I would like to resize all the named ranges on a worksheet, where I have about 30 columns next to each other, so the LastRow of them is the same. This is actually a table, where sometimes a new row will be filled in completely. That is why I need to enlarge all the named ranges (all...
  16. S

    Dynamic Named Range Based upon Column A

    Maybe this is a simple thing and I am over complicating it. I think that I have it solved but I just wanted to check to make sure, so any input you have is greatly appreciated!! I need to create several dynamic named ranges, each for a different column. They are single column ranges, 1...
  17. X

    updating a named range

    Hello, I have a named range (rangeAdded) that is created with an inputbox rng = Application.InputBox("Select a range", "Obtain Range", Type:=8) ThisWorkbook.Names.Add Name:="rangeAdded", RefersTo:=rng For example, rangeAdded = Sheet1!$D$3:$F$5 Next, I use the inputbox again and...
  18. Johnny Thunder

    VBA - Format how code returns value of Named Range - Excel 2010

    Hello All, I am working with a userform and need to have a named range value returned as a format number. Currently my named range ("PrgB") returns the value = 51.515151 I need to have this format as a 2 digit number = 51 but cant seem to get this done. Any help is appreciated! my partial...
  19. Johnny Thunder

    Create Dynamic File Name Using Named Range

    Hello All, I am working on a code and trying to insert a named range into the file name reference but I am getting an error "Constant Expression", not sure what I am doing wrong so maybe someone might spot it. Sub CountFiles() Dim xFolder As String Dim xPath As String Dim xCount...
  20. B

    VBA - replace all data in a named range with data from a separate workbook

    Hi - I am looking for code that will copy data from one file and replace the data in a Named Range on a separate Excel file with this copied data. I need the Named Range to keep the same name so that the pivot tables that refer to the named ranges will continue to read from the same range. I...

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