named range

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

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

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

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

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

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

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

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

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

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

I have searched the web for a solution to my question with no luck. Here is my issue: I have cell A1 with a date (any date), I also have two named ranges. One named Holidays and the other one named Payroll. They are used to identify the company's holidays and the payroll dates. I need to...

Hi guys, I want to be able to use a value in a cell to give a ROW a named range name. The reason : I have 500 of them to name. I can easily dynamically pop the name I want for the row in a cell ( in this case I column G). Ideally, I want to write a macro to step through the rows, where it...

My objective is to use the Worksheet_Change event to test if any cells requiring a value have been cleared, and then to retrieve the default values and put them in the cell. All the cells requiring a value have a named range, and all the default named ranges are the same, except with the...

Excel 2018 conditional formatting for duplicates is limited to the number of rows at the time the conditional formatting is applied, whether by a formula (such as COUNTIF) or by selection of the highlight duplicates rule. Using a named range in a formula simply reverts to the actual cells within...

I have a named range without blanks in it. I have configured cells in a column to be validated against this list. If I type in a value that is not in the list and tab out of it, I get the expected error message, but if I leave the cell blank I get no error at all when leaving the cell. I have...

Hello All, I am working on a new project and I have hit a road block. I have searched the interwebs for a solution to my problem but was unable to find a solution I could cater to my issue. My Problem I have a List Column A ("A1:A64") of Unit numbers and in Column B a corresponding list...

Hello all - I am hoping someone may have some input on this, please: I have created 5 named ranges from a table. Each named range is simply one column of data. Then created a lookup for the (names of) these named ranges (names match exactly, etc.) Once I had a lookup list, I then created a...

Hi Everyone, I'm trying to pull a Named Range using Vlookup into a Hlookup to return a text value. I've tested the individual parts and they work fine but when i put them together I get "#VALUE" as a result. The formula is: =HLOOKUP(E$1,(VLOOKUP($B2,'Emp Lists'!$B:$F,5,FALSE)),($D2+1),FALSE)...

Hi I'm trying to make multiple charts of previous created named ranges, but i simply can't get the VBA code to work when referring to a cell that contains the name of the Named Range. It looks like this: Sub Top25_Charts() Sheets("Top25Graphs").Activate Set peerDataSht =...

I have some code that works perfectly with a normal pivot table, but does not work if I apply it to a pivot table in a PowerPivot workbook. After doing some research, it seems that VBA doesn't exactly work as usual with PowerPivot. I have a named range of values and I'm trying to filter the...