named ranges

I want to create a chart that is automatically updated, both when a new row or column is added to the spreadsheet. I created a name for my dynamic range, using =OFFSET(Top!$B$4, 1, 0, COUNTA(B:B)-2, COUNTA(5:5)-1)] <tbody> a b c d e g 1 2 3 4 Top Customers...

Hi, Is there any way for a named range to be accessible to all users of a network rather than just the worksheet? My problem is: I have a formula that calculates the xth workingday in the UK taking into account public holidays, bank holidays etc. These dates are held in a named range. My...

I am trying to find a way to use VBA to change the name of a Defined Range. Everything I have found so far creates a new range and then deletes the old range. I have used the existing named ranges throughout a large workbook, so I don't want to delete the existing named ranges. Also, I have...

I have a range (a1:b26) named alphabet on sheet one, can I reference that range on sheet 2 for example e10 which will put the contents of each cell in "alphabet" into e10:f35 ?it seems every time I try to work with named ranges I get it wrong using 2010, ut might need it to work on 2007 as well?

I am attempting to delete external named ranges after a sheet is copied out of a source workbook (the template). I have tried both the following codes, but neither one does the trick. The code is in ThisWorkbook (not a module), and I have tried it with the code both in the template and the new...

I have created a .xlam file with a tab named 'Tables' in the spreadsheet that contains named ranges that are passed into the various UDFs that I have created. If the value passed into the function through 'Table' or 'Table2' does not point to a valid named range the function returns the #VALUE...

Hi Guys, long time lurker 3rd time poster. I have four named ranges (Segment, Keyword, Impressions and Dropdown) and I would like to create a formula-based ranking of keywords by impressions and clicks. Using the following array formula, I am able to return the correct values for impressions...

Hi, I am trying to write an IF THEN statement that checks to see if a cell is less than certain cells on a different sheet. I got the macro to work with hard inputs, but I can't seem to figure out how to input the ranges I would like to input. Below is my formula: ActiveCell.FormulaR1C1 =...

When I make copies of tabs in one of my workbooks, I get ~50 copies of the following message: "A formula or sheet you want to move or copy contains the name 'BO00CEC7CE7547428FA7C8FFFF60CD149A', which already exists on the destination worksheet. Do you want to use this version of the name?"...

Hello! I have an excel workbook and I would like to define named ranges for this workbook in another workbook. The first workbook is a template that many people will use and the named ranges will change so I figure changing the list excel (workbook 2) will be easier than giving everyone a new...

I have a list of accounts that has charges made against the various counts on a daily basis. Each account has a unique 7 digit project code that is associated with it, listed on the master log/ list of charges. On a seperate reference worksheet, I have a named range called "LU_PROJECT." I...

Dear All, Is anyone aware of a quick way of deleting all named ranges within a given workbook? I can loop over them, but it takes forever. (I've got about 20,000 names in total). Turning the normal things off doesn't do much good either (e.g. auto-calculating, events, etc)

Dear All, Programatically speaking, can anyone think of a way of checking whether an arbitrary cell is part of a named range (that is, short of looping through an entire book's named ranges checking for intersections)? (If it helps, it can be assumed that all the named ranges consist only of...

When you refer to a named range, does it need to be qualified? I'm sure I've referred to named ranges in the past without qualifying them with which sheet they're on, but just today I'm getting "method 'name' of object '_global' excel" failed". Am I on drugs to think this ever worked? Or have...

Can anyone shed some light on how to find the intersection of one named range with other named ranges? My thought was to loop through the named ranges excluding the common one, and add them to an array. I haven't found how to do this. Here is the code, including all my thoughts and attempts...

Hi, I am trying to locate a specific value (using FIND) in a different ws and then need to get the ROW info so I can grab data from cells in that row to populate in my active worksheet... I pasted the code I'm working with below, but I am guessing at how to get the row info and have been unable...

Folks, Please save me from lunatic asylum! I want to position the focus onto certain specific cells, each of which I have defined as named ranges. Effectively these are starter cells for distinct sets of calculations. I want to give the user a choice of which starter cell to use. I want...

I have designed a few somewhat complex graphs in Excel 2007 and whish to deploy these as an add-in. I have hence added the sheets with the graphs into my add-in and created a few buttons to copy this sheet into the ActiveWorkbook. The problem I'm encountering is graph is using several named...

I am creating a group of interactive excel forms They are all in one workbook, but the coding is extensive with many VBA objects on each sheet some of the sheets have over 25 pages of code I am also using named ranges for any cell references scoped to individual worksheets to enable copying of...

I’m hoping someone can see where I’m messing up with my code. I’m trying to name several columns based on their heading name. The headings are in row three and the actual data starts in row 4 and goes down from there. The problem I’m having is that the named ranges are changing based on the...