named range

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

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

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

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