named range

Hi Everyone, I'm trying to pull a Named Range using Vlookup into a Hlookup to return a text value. I've tested the individual parts and they work fine but when i put them together I get "#VALUE" as a result. The formula is: =HLOOKUP(E$1,(VLOOKUP($B2,'Emp Lists'!$B:$F,5,FALSE)),($D2+1),FALSE)...

Hi I'm trying to make multiple charts of previous created named ranges, but i simply can't get the VBA code to work when referring to a cell that contains the name of the Named Range. It looks like this: Sub Top25_Charts() Sheets("Top25Graphs").Activate Set peerDataSht =...

I have some code that works perfectly with a normal pivot table, but does not work if I apply it to a pivot table in a PowerPivot workbook. After doing some research, it seems that VBA doesn't exactly work as usual with PowerPivot. I have a named range of values and I'm trying to filter the...

I want to add multiple filter items to a pivot table, and these filter items are from a named range in the current worksheet I'm getting the error "Unable to set the Visible property of the PivotItem class". What am I doing wrong? Sub PivotUpdate() Dim PI As PivotItem Dim vRNG...

Hi experts! In our company we have a program called 'R3PM' and we want to use it as a named range. But we get the error: "The syntax of this name isn't correct." Why do we get this error? Is it because letter 'R' is reserved and after it comes a number (3)? Thanks for the answers! Roy

Hello All, I am working on a project that will Group/Ungroup specific columns based on a loop. for ease of maintenance I have created Named Ranges for the groupings to Expand or collapse the groupings based on a variable in a list. Here is the list Excel WorkbookABC1DivisionsNamed...

Hello everyone, Does anyone know if you can create a variable part in your named range. I don't want a dynamic named range I want to literally change the named range. So imagine you have a named range : IncomeStatement.17.18.AfterBoardAdj I want the 17.18 to change to 18.19 by linking it to...

Hi, I'm trying to copy a named range without having to have the name of the range hard coded but having difficulty getting this to work, attempt below but it's not working as I expected it to: This is at the top of the Module as I'm using a UserForm to define the variable site_name: Public...

I know there have been numerous posts about this error message, but none of the fixes has applied to me. I'm exporting to Excel from an Access table, and when I open it I get an error message prompting if I want to recover as much as possible. When I do, I see: Removed Records: Named range...

Hello :) Please could someone help me write a formula, that looks up between workbook1 and named ranges/tables on workbook2. In book1 I have a "Role" column (D) and then a "Name" column (E). In book2 I have named ranges (also made into tables) that are headed with a variety of roles. One of...

Hello All, I am struggling to find a way to COUNTIF the rows label 'Qty' are less than a value. I have tried naming the range but COUNTIF doesn't seem to work on a named range. Ultimately I would like formulas to for Qty < 30, Qty < 40, etc. I would do the same with time (formatted in m:ss)...

Good Morning! I have vba that purges data for public posting, then saves each tab (named range) as a separate pdf to combine & post to the web. I'm getting a Run-time error '1004' "This formula is missing a range or a defined name" on Named Range(Table_7), on Tab "Table 7", when trying to save...

I have been provided a worksheet which I am expanding upon. When I selected the first tab of the sheet yo copy as a template for a new tab I get the below message.. "The name '_1_123Graph_ACHART_9'already exists. Click Yes to use that version of the name, or click No to rename the version...

Hi, I have a sheet with data points and another reference sheet with the different ways to write different body parts. The idea is to see which body parts/ appear in each data row, but because there are multiple ways to say the same body part, I have put the different variations of body part...

Hey Guys! I immensely need your help for the below scenario. I am trying to find a way to address range in a formula. The problem is that, the range is created dynamically. Please refer below image further. Here I have 2 tables say Table 1 & Table 2, these tables are snippets of my actual...

HI There, i require help trying to write a formula i have the first part working fine as per the below =SUMPRODUCT(COUNTIFS(INDIRECT("'"&SheetList&"'!AF:AF"),">"&TaskID!$A25,INDIRECT("'"&SheetList&"'!AF:AF"),"<"&TaskID!$B25)) TaskID A25= -1 TaskID B25= 8 I have 3 sheets and i have...

Hi, I am trying to show the Data Validation Source in the cell which has displayed "Click here to view available values". Any help would be appreciated. Thank you in advance.

Good day guys! I'm trying to use a hidden named range to hold the value of a date that I can refer to in my VBA formulae. So I've created a named range called "ExpiryDate" and it does not refer to a cell, but directly to: "=DATE(2018,12,31)" So using vba, I'd expect...

Hi All, I would like to resize all the named ranges on a worksheet, where I have about 30 columns next to each other, so the LastRow of them is the same. This is actually a table, where sometimes a new row will be filled in completely. That is why I need to enlarge all the named ranges (all...

Maybe this is a simple thing and I am over complicating it. I think that I have it solved but I just wanted to check to make sure, so any input you have is greatly appreciated!! I need to create several dynamic named ranges, each for a different column. They are single column ranges, 1...