named range

Cross posted at VBA to insert or delete rows in named range based on spill range I have a named range "nameList" (B3:E20) that are populated by a spill range from dynamic array formula in cell B3, and there's a table just below cell B24. If the spill range row count are less or more than the...

I need help in looping the code below trough my named range or just skip blank rows. Below code works fine until it should skip rows which should not contain textbox value. My textboxes for this code starts at 58 and runs trough 66. But the value from theese textboxes should be pasted to cells...

I need a solution on how to create a named range based upon cell values. The cell values are variable, and the sheets on which the named ranges need to be created are hidden from the end user, hence the need to automate it. I've had some success with the actual name of the range as per a cells...

Forgive me if this has been answered somewhere; I've looked and can't seem to find a solution on the board. I'm using dependent dropdowns in Sheet 1 [Main] via an indirect() in Data Validation from named ranges in Sheet 2 [DVS]. So, you choose the "Parent_Choice1" in Cell A...and then... Cell...

Hi, I have a listFiles named range to return a list of files of a specific folder into Excel. I use the following formula: =IFERROR(INDEX(listFiles,ROW()-ROW(A$2)),"") I was wondering if there is a non-VBA solution to automatically/live update the files list in the Excel named range whenever a...

I have a recipe book spreadsheet with a navigation bar to different categories (ex. PREP or HOT etc.). When Selecting PREP, a second list appears with all HYPERLINKS to all of the prep items. The user clicks on the PREP item and the recipe appears. I CAN MAKE ALL OF THIS WORK, but it's a little...

Hi all, hoping someone can help with this one. I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or...

Hello, I'm trying to use a calculated Named Range in VBA and I found myself in the position that I cannot do that directly. What am I talking about? In the example given in the picture bellow, the "s" Named Range is calculated using the values from the "a" and "b" Named Ranges. You can then...

Hello all, I recently updated my MS Office version, and am encountering a new problem using IF(AND with named ranges. As can be seen in the image below, the named ranges work fine for a simple IF function, and the IF(AND formula works fine if I use the cells. But when I use the named ranges...

I have a series of formulas that reference a Named Range in the same Workbook. Sometimes I need to use a different Named Range in those existing formulas. I would like to put the Name of the Range in Cell B3, and use that cell in my Formulas. Then if I change the contents of Cell B3 to the Name...

Hi there, I'm trying to adapt something that Tonyyy and This is my Answer helped me with earlier. I have a worksheet that has columns of data. I would like to loop through the columns starting at the second one (B) and create a named range for the last 10 cells in each column. So column 2 might...

Hi all, I'm trying to create a set of dynamic charts that will change when I update a dropdown (that has a named range). I've set up the set of charts using a series of named ranges that are broadly formulae that do some sort of dynamic OFFSET to get a range series. Within the template sheet I...

Hi there. I am for hours searching an solution but nothing till now. Or it is impossible or I just wasn't able to reproduce what I've sen on my workbook. So, here it goes: I've set a named range com a list of banks (on sheet3!) and I want to maintain that way because there is the possibility...

I have a workbook with 25-30 worksheets and every single cell that would have a cell reference uses a named range instead. I am trying to replace them all with cell references using the following macro (found on google): Sub AbsoleteNamesWithRelativeRefs() Dim Rng As Range Dim WorkRng As Range...

Hi all, Hopefully an easy one In the below table, if a cell in named_range_2 has a number, I would like to return the corresponding value in named_range_1. I am working with a datasets with 1000's of rows if that makes a difference named_range_1 named_range_2 def 123 ghi hjk lmn...

Hi, I was hoping someone could help me with the following issue: I have an input file with conditional formatting helping me to verify input data. However, since people will be able to add lines in the input template, this conditional formatting will be split into many once people add new lines...

Without using VBA I would like to have a formula to first select all cells in columns A thru E where data exists while disregarding all blank rows below this data. Then with this selection current run the copy as picture routine which is a 2 pick from the menu. First from the Menu's Clipboard's...

Hi all, Using Excel 365. I would like to use a Named Range that contains a Tax_Rate in a calculated field This way, users can easily change the rate on an Input Sheet if the rate should change. It seems the calculated field does not recognized the Named Range. What are some other options...

For instance I have a named range called DashboardSumm, how could I use a line in VBA to set it's reference range to : =Dashboard!$B$3:$P$2322 before then using macros to effect changes on that named range?

I import a large csv file. I know the first column is reliable for counting used rows. Later as columns are added, column A will become column B, C, etc. I need to refer to the last row in probably 20 different modules. and after the first column is inserted, "LastRow" is now in column B, etc...