named

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

I have a pivot table named PivotTable2 on a Worksheet named Three Pivots. One of the FILTERS is named DATE_DUE. I need the filter to have only the last five days checked. Currently I have the start date in cell C5 and the end date in cell C1 (If I don't need the cell reference, that is okay)...

Is it possible to have a macro in my personal workbook that will open a pdf named job list thats in a certain folder.

Hi All, I wanted some help regarding VBA for worksheet passwords. I have a worksheet named "Code" in my workbook. Cell A1 in this worksheet has the value COSPASS. I have another worksheet named "Logs" which is locked using the password COSPASS mentioned above. I wanted an event based VBA...

right now i have this... With pf For Each pi In pf.PivotItems If pi.Name = "811" or pi.name = "911" Then pi.Visible = True Else pi.Visible = False End If Next pi End With but i'd like this to be more flexible and dynamic...

Hi, I have two data tables, one for 2017 and one for 2018. Next year I'll have another table for 2019. I am using named ranges for column names and I am using the named ranges in SUMIFS formula. However, since there are two different tables I can't figure out how to use SUMIFS to either...

I have a lot of Named Ranges that are coming from our File Management system metadata. Usually on workbook open it takes some time (up to 5 seconds) to load these values to cells. I have some other processes linked to these cells. For example showing/hiding shapes if let's say cell A1 > 1. The...

Hi I named A1:A10 as myrange1. Then I inserted a empty row between row 2 and 3. To my surprised now myrange1 is actually A1:A11 ? Is that by design? if yes, then what is the point of naming range when I can not grante, it will point to the cells I want. Thank you

Good Afternoon, I currently have a list of dates starting in cell A2 which lists every day of the current year (1/1 - 12/31). I also have some named ranges that reference columns A:U for each month (Ex: January is A2:U32, February is A33:U63 etc) . I'm running into an issue where since next...

Hi there, I have two columns of data that I want to add as an item/key to a collection. I have the two columns individually named but I can change that if necessary (i.e. two columns under one name). What's the best way to get these data into a collection?

Named Ranges become corrupted readily. I am writing a fairly large application using VBA and named ranges extensively. I have a major problem - it appears that in the event of any error in coding, wherever and not related to anything in particular, the defined named ranges are the first thing to...

Very frustrating. I've created a named range, let's say 'Data' for the range A8:O300. I use 'data' in an Index/Match lookup and it works fine. Now, I need to use the same Index/Match formula on a different sheet. I realize that the named range stays, so to speak on the first sheet, and the...

Hi All Before i get to involved with mu approach. Is this even possible. In a userform i have a combo box linked to a named range in a sheet. 8 options. I then want another combo box that displays a variable named range dependent on the previous combobox for instance combo box 1 has the 8...

I am trying to update a range of cells in my database which is an excel sheet with another input range. The range in the database is named "MyRange". The Input Range is named "Input" When I use this code: Range("MyRange") = Range("Input") nothing happens When I use: Range("MyRange") =...

Dear Friends, There are 43 columns Sort Column Header Named Disposition. But Disposition column will not be in defined column number (each time when we receive file columns will be shuffled)

Need VBA code to copy and paste as values from a specific range A1:AE36 in a worksheet named "Matrix DSR" and workbook named ""Daily Sales Report Master Update File - CQ_v2" to a specific range A1:AE36 in a worksheet named "Matrix" and workbook named "BMH Daily Sales Report thru 08-21-19 run...

Hi all, I have a data set as follows: Data Headers A1: U1 Data: A2:U395 The number of rows in the data changes every month, and so I have a dynamic named range I want to use (formula below) which exclude the last non-blank cell in the column. The problem is I need to apply it to the whole...

Hi all, Stumbled across this issue when trying to help someone else on here, Is it possible to name a range as a cell reference? My assumption is no this is not possible but worth an ask. E.g. I want to name the range N2:N3 as "h1" but that refers to a cell so it renders impossible right...

Good morning, Is there a quick way to name a set of set each with its unique name? I have a column of cells, and I want cell A1 to be named "Import1", cell A2 to be named "Import2", etc. Is there a way to do this automatically, or will I have to manually name each cell? Thanks

Hi there. I have a dynamic table named Tabla, with two columns named A and B and I want to every cells on that columns (new ones that can be added with TAB key increasing table size) have the same comment. In the screenshot that i've attached, you'll see the first row commented (with LIMIT...