named range

I am extremely new to VBA, so I hope that this is easy to do and I am just missing the obvious. I have code that defines a named range as the active row, and another that does the same for the active column. How to I combine the two into one sub so that I can automatically calculate active row...

0 I have a piece of code that is trying to overwrite the value in a named range, but I am getting <Object doesn't support this property or method> Sub CheckStuff() If Evaluate("Table1RowCount") > Evaluate("Table1LastRowFixed") Then ActiveWorkbook.Range("Table1LastRowFixed").Value =...

I downloaded and installed xl2bb but my Windows 11 system is refusing to unblock it. I've tried unblocking it through system settings but no success. I've tried placing the add-in in a trusted folder and still not working. I am designing a worksheet which will generate a random selection of math...

Hello, I'm not having any luck using wildcards to return values from a table of data based on a list in a Named Range. I'm using the following to return a list of books that are part of a given Series. However, due to multiple values in the Series column, I need to be able to use wildcards...

Hi Experts, Can we make reference to Named Ranges Dynamic? for eg. I have Named ranges SD23 SD22 where number part represents last 2 Digits of an year. Now I want to use reference to these named ranges to pull their values. Using =SD23 is working absolutely fine. But thought crossed my...

Is there a way I can disable creation of Named Ranges in a specific workbook for all users? I didn’t see anything in the Protect/Lock menus. If not, is there a way to auto-alert if Named Ranges exist when the file is opened? Similar idea as the “Ask to update automatic links” prompt. If not, is...

Hi ... I've got this Excel sheet contaning 29 columns from E:AG with different words. You see, the norwegian alphabet has 29 letters. Columns varying from a 100 rows to a few hundred thousand. I want to, in a search cell, type for example, ??rem??, and get a one column list of all seven...

Hello :) This is my first post. I've been a longtime lurker and always found what I needed without posting. But this time I've searched for a long time and tried different formulas without success. I am trying to construct a formula that will return certain text based on the text in two...

For context, I currently have a VBA that copies a sheet from sourceWB to destWB. My issue is that when you copy a sheet, the named ranges get copied over to the destWB as well. I'm looking for a VBA code that deletes any named ranges that refer to the sourceWB. I'm thinking of looking for any...

I've got the below setup, trying to have a filepath reference the workbook name listed in CurrentIndia, highlighted below. I've named the range officially CurrentIndia in NameManager: But everytime I edit the formula or re-confirm it, the Update Values window pops up everytime, and I have to...

What does this error mean when I try to run the code? Column A and B are new, and meet criteria. I've tried column B with the full formula, = sign included, and without, as well as with ' in front to show as a string. I also keep getting this error as well

Hello, all! I've been searching all over the web to find an answer to this, but I can't seem to find anything. I hope I'm able to explain properly what I'm encountering: I created a budgeting tool for my coworker. It consists of four sections: AR, POs, Overhead, and AP. There are 10 columns of...

Hello, I am working on a template for charting data. I want to be able to use a dynamic named ranges for series data so the chart is dynamic and I don't need to manually update the series data everytime. Sample number is x axis and Average Weights is the y axis. I made the dynamic range names...

Good day! - I need help on modifying the code below to do the following: On a named range from columns C to J, I would like to add a bullet only to any text entered on Column D6 and down, if any cells on column D already containing a bullet has to be ignored so not to end up with multiple...

Hi Excel Gurus, I am attempting to set up a spreadsheet where I can update data in tab 1 on a monthly basis, then refresh the pivot in (tab 2). In tab 1, when I paste the new set of data on top (same format), when I refresh the pivot (tab 2), my power query disappears - no data appears in the...

Is there way to create a dynamic named range based on cell values from other columns? The cells in the named range may not be contiguous. For example, I have a list of holidays or other observed days. I want a dynamic named range of the Day column to reference only those marked as Type...

Hello, I have somewhat of an advanced question... I have a long list of names in a column in excel (range name, "Names"), what I want to do is create a code that I can run that will open a template (named "CART") and based on the list of names the code would open a copy of the template and...

Hi, I have a macro button to open a userform mailing list (see image) which includes a combobox and listboxes. I had written code which got enhanced by member 'beyond Excel' below. Credits to him/her. The goal is to save the Sender, CC and Recipient addresses in named ranges on the data sheet...

Hello all - I've looking al over for a solution to my dilemma at no avail. After extensive Google search I found the below code which is applying Case to anything on column "C" which is not ideal for my need, the question is: Can I get someone's help to modify the code that only applies to Named...

Hi there, I have a section of a much longer bit of code that selects a range of dates and makes a named range that gets used in a number of places. Set dateRef = Cells(rCount, 1).Offset(-175).Resize(176, 1) ThisWorkbook.Names.Add Name:="_Dates", RefersTo:=dateRef Range("a2:a" & rCount +...