Seems like I'm missing something simple here to name a dynamic range. I'm trying to do this without creating a variable for the last row, etc.
.Names.Add Name:="supplierSitesRng", RefersTo:=Range(.Offset(1, 0), .End(xlDown))
Is it possible, when writing a formula, to call a range name from a list of range names? For instance, I have a list of all my range names in cells A1:A7. The specific range name in cell A2 is "Sales_2018" (Sales_2018 refers to cells D12:D47). Now I want to create an index/match formula that...
During the last 2 weeks I've been trying to solve a seemingly unsolvable problem: how to set up a workbook with VBA, where the VBA needs to be signed, and still have users copy sheets in it, without that copying breaking the signature.
There seems to be a narrow escape route, but it's still not...
I have a few cells in a column with different ranges in them. I would like the vba code to loop through this column, read the range in the given cell (eg cell B2 contains "Tables!$B$2:$D$7") and then name the range ("Tables!$B$2:$D$7") what is given in the column next to it (eg A2 contains...
Hi Newbie here
I have a range name which I would like to format using conditional formatting.
When I change the cells that the range name refers to I want the it to format the new range.
This might not be the easiest way to do it so I'm open to alternative suggestions.
Essentially what I...
I need some help here. First time poster.. I need help with my dropdown lists, returning multiple values attached to each entry. If I fill down my formulas it only returns one value; not the list attached. Please PM me if you know an easy fix. Thanks ! :confused:
Does anyone know how to dynamically change the name of a range? Say a range was called Apples which is taken from the column header and I wanted to change it to Pears by changing the column header. Is there a way to do this?
I am not able to use advanced filter on my menu in either Excel 2007 or 2010. I have tried on 2 different computers one with 2007 and one with 2010.
I have range names listed for Database1, Criteria1, and Output1. I check the box for copy to another location (Output1) and do not check...
I have used range names for over 10 years
However, I have a weird situation that I have not seen before and don’t seem to find on any postings anywhere on the internet.
I define a range name and two odd situations occur:
1. when I reference that range name in a formula, it becomes a RELATIVE...
Hey everyone, this is my first post!
I've figured out how to create a dynamic chart, where the last values of my data are forced to be blank using an IF formula. The range that I created for which this works has the following formula...
=VLOOKUP(B2,'10_28_2012 MFC PROJECT V1.xltm'!lower1,6,FALSE)
I need to change the vlookup range name (i.e. "lower1" ) based on contents of an adjacent cell B1.
I surely appreciate any assistance you can give me.
Hello, Excel Friends.
My obstacle may not have a fix, but I must ask. I have a column that has file nos. for matters (e.g., 0B-040300US). The seventh character of the file no. identifies the family it belongs to. For instance, all the following matters (0B-040300US, 0B-040301US, and...
I need to define a dropdown list (either using a combo box or an in-cell dropdown) but the input range (which contains 10 cells) will not always be fully populated. I tried to define a variable range name using offset to only include populated cells, but I can't get it to work.
hello I am trying to define cells name by cells value I have tried activecell.name = activecell.value
but I want more than one cell to define I am trying selection.cells.name = selection.cells.value
I want every cell in selection sets it's name by it's value also i am trying to select a range...