Stack Overflow
Stack Overflow

Questions tagged [named-ranges]

A named range is a defined area, typically in a spreadsheet or document, used for future reference. A range can be one cell in a spreadsheet, or a range of cells.

Named ranges (or defined names) in spreadsheets are used to refer to one or several contiguous cells.

Ranges will automatically shift the while the layout of the Worksheet changes (adding or deleting rows or columns). Furthermore, named ranges can be defined with formulas.

609 questions
0
votes
2 answers

Using named range for conditional data validation

I have a named range called "myList" defined as rows 1 to 200 of Sheet1. There are 20 columns, the 8 first columns are informations about the employee while the last 12 columns are 0s or 1s for inclusion of the employee in each month. Now, I want to…
dan
  • 3,439
  • 17
  • 54
  • 82
0
votes
1 answer

VBA Excel - Avoid not exsisting rangenames when copy/paste data from one rangename to another rangename

From cells in a sheet (Sheets("Omrnavne")) with several Range names written below each other the code has to find the first value (range name) written, find and select the actual range with this name on Sheets("Specifikationer"), copy data, go to…
Sven
  • 3
  • 2
0
votes
1 answer

xlsx4j to evaluate excel formulas

provided that xlsx4j satisfies the SpreadsheetML specs, can the following scenario/requirement be implemented using the library? xlsx4j can read named ranges xlsx4j can evaluate a formula that is defined in the spreadsheetML specs xlsx4j can…
dee dee
  • 3
  • 1
0
votes
1 answer

Get name of the named range corresponding to the given range

How can I get name of the Excel named range from cell range? For example, I'm naming "A1" cell as "Test" in Excel editor, then I want to get this name in C# from "A1" Excel range. Following is what I tried but it`s not giving me the result I…
user3842389
  • 45
  • 1
  • 8
0
votes
2 answers

Set a Chart series source to a named range via Macro

I have a sheet with a existing chart and the proper dynamic named ranges to feed that chart the right data. My problem comes that the sheet is a template that is copied and the copies' charts don't point to the named ranges anymore. The named…
JMichael
  • 157
  • 3
  • 14
0
votes
1 answer

Excel 2007 - Named Ranges

I have a worksheet where data is updated from an external source. The page contains data from today going out 20 days. I have a named range for each column i.e. Today ($D$4:$D$50), Tomorrow ($E$4:$E$50), etc, etc. My issue is that sometime the…
user3890637
  • 17
  • 4
0
votes
1 answer

Named range with colors

I have one sheet with status like that: Status S1 S2 ... S10 And each one have a different color. I'm using a named range on that status list in several places. Is there a way that force that not only the name will be copied but also there colors…
Roee Gavirel
  • 18,955
  • 12
  • 67
  • 94
0
votes
1 answer

Excel VBA Hardcode every Named Range in formulas

I currently copy a worksheet that contains workbook and worksheet-specific named ranges. The worksheet-specific references need to be the way they are, the workbook ones need to be hardcoded. I am looking for a way to fixate every named range that…
Spurious
  • 1,903
  • 5
  • 27
  • 53
0
votes
3 answers

VBA Named Range dropping Sheet reference

I have a named range called "MyRange." It's define as ='Sheet1'!$A:$A. In VBA, I have the formula LastRow= Cells(Rows.Count, Range("MyRange").Column).End(xlUp).Row. It should return the last row with data in the Named Range. However, it returns the…
user2242044
  • 8,803
  • 25
  • 97
  • 164
0
votes
1 answer

Excel vba using table from hidden sheet in vba datavalidation

How to use table from hidden sheet ? I get error on With Range("AI5:AI" & LastRow).Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=MyTableFromHiddenSheet" .IgnoreBlank…
user3722021
  • 1
  • 4
0
votes
1 answer

Relative Ranges in VBA Code and Named Ranges

I have the following formula Range("D3" , "D" & Total_Rows) = "=sum(A1:A10)" If I insert a column before D, this formula now is put in the wrong column. I have been told to use a named range for column D, but with this type of code, I don't see how…
user2242044
  • 8,803
  • 25
  • 97
  • 164
0
votes
1 answer

Where to place reference content for an xlam file

So I have an excel add-in that, amongst other things, contains a huge list of aliases. For example, Country names with their ISO codes, Countries with their continents, etc etc (so that I can easily know that Canada is in America or that Côte…
Amit Kohli
  • 2,860
  • 2
  • 24
  • 44
0
votes
2 answers

How to call a Macro when a named range (cell) is changed

I am trying to call a macro named "RE_environmental" when the cell named "RE_1" is changed (i.e. they mark a X in the cell). I've tried several different variations of codes including these two and nothing is happening: [The first code does work if…
Anonymous N
  • 11
  • 1
  • 3
0
votes
1 answer

VBA: How to programmaticaly create named range pointing to programmatically created sheet?

It seems this question also contains proper answer, Excel for some unfathomable reason won't execute it without error. So the question has changed a bit: Why 1004? Basically I want to use something like (This give me 1004): Dim rngTmp As Range For…
przemo_li
  • 3,932
  • 4
  • 35
  • 60
0
votes
2 answers

VBA: Naming a Range

I have searched for a solution but can't seem to find one. If one exists, please point me to it. The question is how do I name a range in VBA. wrkSheet.Range("A1").Name = "Test" Works fine but as soon as I change it to …
MathLover
  • 77
  • 1
  • 3
  • 12
1 2 3
…
40 41