named ranges

  1. Phil Payne

    Dynamic Named ranges in formula.

    Hello all, I have set up the means to determine and count the number of public holidays during a year on a month by month basis. They work but I need the calendars to be dynamic to allow local holidays to be added. I have tried to set up a dynamic ranges to work within the existing formula to...
  2. littlepete

    convert to table but loose all macros ?

    Hello, I can see the advantages for an excel table, i've tried it before, but all the articles give always examples that belong to the mathematics and statistics not to an address list, or text containing list... when i try to convert to a table i immediately see that my macros dont work...
  3. R

    How do I use listobjects for Index/Match in VBA?

    I'm want to use tables and column names when using index/match with vba. I can get my formula to work when I enter a fixed range like this: Sub NotAckMe() Dim sourceTbl, apolloProcessed As ListObject Dim apollo As Worksheet Dim sourceRows As Integer Dim estimator, b As String Set apollo =...
  4. B

    Vb msgbox with hidden named ranges

    Hi, I’m new here. I figure I’d get that out of the way right away. I’m also relatively new to the concept of implementing VB into my excel worksheets. I maybe a bit more than a novice but not by much. So my issue what I’m trying to attempt, is I have a worksheet with multiple drop down...
  5. S

    Cell Reference Named Ranges as Arrays

    Hi, In an excel file we have various named ranges. Ideally in a column we could reference these as arrays in an INDEX formula as a name so the array would change depending on cells in a column, just like how the row or column reference numbers can change. Do you know if this is possible as...
  6. A

    Name Range across multiple (200+) sheets

    Hi, I have an excel workbook with 200+sheets of data tables. I need to create a named range for each table. That is for each table, I go in and highlight a range - say A22:S50 and then name it Table1, Table2 in the name box or I can do this for name manager. Is there a way to automate this...
  7. C

    Return cell value based of row Named Range and Column Named Range

    Hi All I want to return the cross reference of 2 named ranges. There is a sheet called Front Page where i want to return the result and the information is on a sheet called Commission Row named range = Partner Column named range = Finance Both of the named ranges will be referenced in as...
  8. M

    VBA Code to Copy and Paste 100+ Named Ranges with Looping

    Hi- I am new to learning VBA and I need some help! I am looking for a VBA code that will loop through all 50 tabs within an excel workbook and search for any named range that starts with EQUITY and copy and paste all named ranges into one single tab within the workbook. In this case we can name...
  9. A

    Help with VBA combobox references

    I am familiar with the basic functions of excel but do not have extensive experience with VBA--I have been trying to learn but I cannot seem to find an answer to a specific task which I am trying to complete. I am working with a data table (shown above) of Units with a set number of designated...
  10. M

    Excel Named Ranges

    I am stuck, and I am not sure if there is even a solution for my block. This is what I have: I have numerous named ranges. For example, I have named ranges for vendors, the named ranges are: Vend1Eval, Vend2Eval, Vend3Eval....etc. I want the ability to set the appropriate named range in a...
  11. S

    Shared workbook - Issues with Dynamic Ranges & Tables

    I have a number of different workbooks, let's just call them workbook 1, workbook 2, etc.... Each workbook has multiple worksheets referencing different data from the other workbooks/worksheets. I originally had different named ranges (static) in each worksheet, to make things easier to...
  12. K

    Moving sheets between workbooks with the same named ranges

    I have two workbooks, each containing a similar "Reference" sheet of global constants, which are defined in about 100 named ranges. The named ranges are the same in each workbook and are scoped at workbook level so they can be used by other sheets in each workbook, but the global constants...
  13. B

    Naming Ranges using VBA

    I have a database that will be constantly changing in length and for purposes of conditional data validation, I want to name hundreds, potentially thousands of ranges. I have made it far enough to get a table on a separate sheet with what I want the name of each range to be in column A and the...
  14. X

    check if cell in named range

    Hello, I have two sheets sheetA and sheetB with two names ranges rngA and rngB respectively. rngA in sheetA has one column and contains cell addresses (like, $F$6, $H$2, $G$3, ...) rngB in sheetB is say $F$3:$H$9 I need to delete cell addresses in rngA that are not in rngB. For example, $H$2...
  15. M

    Selecting a range using name box

    So I'm using the Name Box and Defined Named Ranges as an index to jump around to different areas on my worksheet. I have noticed that some of the ranges, when selected via the name box, will put the top left cell of the range at the top left position on the screen (like cell A1 is on a new...
  16. N

    Long processing times...Named ranges with dynamic data?

    I have a workbook with lots of formulas and sheets. It is updated weekly and the data grows irregularly with every update. As of right now I have my formulas referencing entire columns in order to capture all new data. This is starting to catch up with me, as the processing time is detracting...
  17. J

    Adjusting Named Ranges Dynamically

    Good morning, everybody! I have to update a *ton* of tables in an Excel spreadsheet, rolling them forward for the new year. For example, if WRSState is in cells A6:H15, I need to copy rows A7:H15 into A6:H14, clear A15:H15, and then make a couple of other edits that i should be able to figure...
  18. C

    find all named ranges that contain the selected cell?

    How do I find out if a cell I have selected is included(or not) in one of the numerous named ranges in my workbook? It would be nice to do this outside of coding. Ideally I would like to select a cell and have a list of named ranges that include that cell. Why.. because I have inherited a huge...
  19. G

    Execution error 424 object required

    I had a simple marco to hide a sheet and some rows when a listbox is clicked. it ran fine in the listbox's sheet's code but I had to move it to a global module in order to go hide rows in another sheet. Now it says the objects don't exist. Here is my code Public Sub ActiverLait()...
  20. A

    Sub Worksheet_Change with named range is not does not work!

    Excel Friends, I set up C4:C12 to have some values that are added up at C13. I named C4:C12 as SelectedValues, and I named G3 as TotalValue and made it equal to C13. The following worksheet event does not work. Can somebody tell me how to fix it? Just one requirement, the ranges need to be...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back