named range

  1. P

    Populate a Userform Caption using a Named Range

    Hi All, I'm new to VBA so hope this question isn't too dumb! I'd like to add a "Key" to a user form that can dynamically update should it need to. Currently the user form has a number of comboboxes which have shortened codes in them to make entering the data faster, and so the resultant...
  2. D

    Creating hyperlink for specific sheets while creating those sheets

    i wrote a code that will create as many worksheets and name them for each cell value in a named range. my code gets my template sheet, and duplicates it and renames each one accordingly. on my template sheet, i have a navigation pane in column A, so from A17 downwards, id like to create...
  3. M

    Create Named Range From Values in Adjacent Cells

    Hello, I am trying to create a series of several named ranges in a single column that are defined by the values in previous columns using VBA. For example, I have one column for "colors" and another for "shades". The third column is their product numbers. I would like to group the product...
  4. D

    Power Query and Named ranges with Data validation

    Taking literally my first steps in Power Query, so please bear with me. I need to compile a list of XLSM files in a folder with some metadata (name, folder path, date accessed) - this is all fine and functioning through Excel Get Data -> From Folder function. However, I also need to include...
  5. S

    Using a Named Range List as a criteria in COUNTIFS

    I'm looking for some assistance using COUNTIFS with a named range (list) as a criteria. It seems to me like it should work like this, but it doesn't. After some research I found a place that said this would work if the named range was a single cell, but I need it to reference a list, as I need...
  6. A

    dependent data validation

    I'm trying to get a dependent data validation list set up. I know I'm supposed to use the indirect function along with substitute (because the first list has spaces in the options). I think it has to do with my named ranges. I've added an image with a snapshot of my named ranges. I'm...
  7. M

    Challenging/Complex named range or Idea

    Hi folks! Can you please help me with the below? I have 2 columns AAA 12/1/2019 AVC 11/2/2019 AAF 11/3/2019 AA 11/4/2019 AAA 11/5/2019 AA 11/6/2019 AA 12/7/2019 AA 11/21/2019 AAF 11/15/2019 AVC 11/11/2019 I want to define named ranges depending on column A value. For...
  8. C

    Improving my Formula

    Hi All ive created this formula and it works perfect, but as your see in a sec its rather big. Can anyone think of a smarter way to get the same result. The below checks to see if there is a date in the BOLDED cell and if there is it moved onto the next till it cant find a date, when it cant...
  9. W

    Using named ranges in Solver VBA

    Hi, I want to run Solver from VBA, and I would like to vary the "ByChange" cells depending on certain conditions in other cells. (This is to minimise the number of ByChange cells, and remove any redundant cells i.e. ones that definitely will have no effect on the target cell). This means that...
  10. T

    Create dynamic named ranges to call from userform

    Hi, If anyone can give me a kickstart with this it will be appreciated. In the linked excel file there are 2 tabs. I want to work with the first tab, GM SOR's. The first row has identifiers or column headers. The first column, Sub Trade has a number of trades listed multiple times. Each...
  11. M

    VBA to create a named range on each sheet with name of value in cell A2

    Hi there, First time poster, but long term user of the help on this forum I'm in need of some help. I have a workbook with 468 sheets of data. Each sheet has a table in the range of A4:AA500. I need to create a named range for each of the table ranges on every sheet and name it as per the...
  12. A

    Macro to print worksheet specific named range in footer for that worksheet

    Hello, I'm still a beginner with VBA/macros but I've done my head in trying to work out the following two questions on my own so anyone's help would be greatly appreciated. I have a workbook with a number of worksheets, many of which have a worksheet specific named range for a cell called...
  13. E

    Named range creating reference to "MXL2.xlam" in named range

    I have never had this happen before in all my work with named ranges. I created some named ranges to reference INDEX() functions that are row specific in a table. For example: "=INDEX(A6Bals,LastRow)". The Named Range works fine until I close and reopen. When I reopen, all of my cells with...
  14. A

    Delete All But First 10 Rows of Named Range

    I have a spreadsheet that adds additional rows to a named range. That part works like a charm. I need help with a macro to reset that named range to 10 rows; i.e. delete all but the first 10 rows. It would also be needed to limit the number of rows in the range not to be less than 10 by...
  15. F

    Naming ranges in dropdown list

    Hi all, <tbody> Manufacturing line Type1 Type2 PPA New product PPA ELH Basic PPA Old product ELH Advanced ELH </tbody> I am trying to create dependant dropdown lists so that based on Manufacturing line, Type1 and Type2 are possible to be selected. So if I select PPA New product...
  16. J

    How can I use Rank.Eq, Countifs, and Offset to Rank a Filtered Table

    <tbody> Language Criteria1: Wait time(min) Criteria2: Success Rate Criteria3: Volume EN 30.5 61.5% 200000 EN 70.0 75.3% 4765 SP 10.0 57.34% 8000 SP 47.0 49.6% 2000 SP 47.0 55.81% 310000 </tbody> I've been all over this forum and google trying to find out how...
  17. R

    My VBA creates named ranges with special characters (!) - how can I delete that?!

    Hi all - please advise. How do I delete named ranges with special characters. Or prevent my vba from creating named range with special characters? My goal is to duplicate a sheet (eg Sheet A) that contains name ranges to another sheet (eg Sheet B). Due to duplicated named ranges - the name...
  18. J

    range Object persistence problem

    Hello, The following is attempting to iterate an array (2D String array) and use the values in order to create new powerpoint slides- Dim rng as range Dim loopI As Integer For loopI = 0 To arrayLength - 1 'array starts at 0 so 1 'Add a slide to the Presentation...
  19. L

    Basic way to check if a table and a named range exists?

    Hi all, I'm finishing up on a project and applying "Security" I'm using Application.Undo in many shapes and forms to create a log and to not allow the users to change the layout, but allow them to edit the data.. Question 1: I have an admin sheet (Sheet1) with something like 20 look up...
  20. W

    Need Named Range Formula to Auto Adjust for Every 5 Rows

    Hi everyone - I am trying to avoid creating hundreds of named range formulas. I have set up an image box to display one of three different images in A2 of Sheet1 if B2 of Sheet1 contains one of three specific values, no image shows if B2 contains the value "0". The formula I use for this named...

Some videos you may like

This Week's Hot Topics

Top