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
3 answers

Change scatter plot XY series to named ranges with VBA

I have a dynamic scatter plot that changes with a slider button. In order to do that i use two named ranges with the offset function, these named ranges vary when i move the slider button increasing or decreasing the X and Y ranges end value. The…
NMPG
  • 13
  • 1
  • 5
0
votes
1 answer

vb, combobox, RefersToRange, Dynamic Named Ranges

Can anyone Please help resolve an issue with ReferToRange in my code. I have attached an example. I am getting a runtime error 1041 application defined or object defined error when the MAIN is called. I am linking a combobox listfillrange to 3 named…
user25830
  • 23
  • 1
  • 1
  • 5
0
votes
0 answers

Output all cells in a named range in Excel?

I have a named range in Excel (called JourneyReference) that contains data to do with common journeys employees make (travel time, distance, etc). I would like to output all of the cells from this named range on several sheets. The reason I am…
David Gard
  • 11,225
  • 36
  • 115
  • 227
0
votes
1 answer

Index Match in VBA for Ranges (finding a loan balance given a loan number and a date)

I was trying to implement the index match combination in VBA to find a number in a range given 2 conditions. The below seems like a great approach, however, my inputs do not come from excel but from a variable that changes in the code itself. For…
user2689979
  • 1
0
votes
2 answers

Excel 2003/2007 named formula appears to store only single value not range/array

Similar to a question by Stephen Roy April 26, 2013, answered by Barry Houdini. I have a named range per this generic…
ian taylor
  • 3
  • 1
0
votes
1 answer

copy cell values of named range in one sheet to same cell address of another named range in another sheet

Is it possible to copy the values of a named range in one sheet and paste them in the same cell location of another sheet? For example, I have named range "old_desk_1" in sheet1!A24:A25 and named range "desk_1" in sheet2!A24:A25. Is it possible to…
user1916075
  • 91
  • 2
  • 4
  • 9
0
votes
0 answers

Dynamic expanding range for excel template

I am an excel user at the most basic level with a programming background who has been put on a nightmare project. Here is what I need to produce: Multi-page excel sheet which will be converted to PDF through the use of a third party tool. Every…
rekordboy
  • 146
  • 1
  • 1
  • 5
0
votes
1 answer

loop through names and delete those not matching specified pattern

I have a Excel workbook in which I import sheets from several other workbooks and then merge the data from these into an "overview" sheet. I am fairly new to vba so this task has taken quite some time, and alot of research. However I have one…
SimonJensen
  • 3
  • 1
  • 1
  • 2
0
votes
1 answer

Dynamic hyperlink in Excel with named range

I have searched for a solution and I believe what I want to do is possible (or maybe it is not), but I can’t seem to make it work. An outline of the problem is as follows. I have some data in column A of sheet Data, the values in column A are not…
Dabur
  • 15
  • 1
  • 4
0
votes
1 answer

Excel OFFSET function error when using TREND in reference

Consider an Excel sheet with the following values: A B -------- 1| 1 5 2| 2 8 3| 3 11 Entering the array formula =TREND(B1:B3,A1:A3,A1:A3) in cells C1:C3 returns {5;8;11}, as expected. Entering =OFFSET(C1:C3,1,0) returns {8;11;0}, also…
dnlbrky
  • 9,396
  • 2
  • 51
  • 64
0
votes
1 answer

Excel formula with named range

I have a question about formulas, it´s not an easy one, I hope someone can solve it. Table looks like this Idx Val Rslt 1 1 3 1 2 3 1 3 3 2 11 13 2 12 13 2 13 13 Named range NR encapsulates columns Idx and Val (without…
MRB
  • 422
  • 1
  • 8
  • 16
0
votes
1 answer

create an Excel Named Range that goes until a condition is met

I would like to create several Named Ranges in Excel that collect values in each column until the cell in a different row is blank. So for instance I have a Named Range called Weeks and the range is from DB3 to FA3. I would to dynamically get all…
dmikester1
  • 1,374
  • 11
  • 55
  • 113
0
votes
2 answers

How to get named range for a particular cell from excel using python

i need to get "name a range" value entered for a particular cell. i entered "name a range" value for (A4,B4) cell in excel,to read cell value we use sh.cell(row,col) but how to get name range value for that cell. i am not getting how to do... help…
user1182090
  • 301
  • 4
  • 7
  • 20
0
votes
1 answer

VBA named range offset

I am trying to write VBA code that will select a named range, copy it and paste it for a certain number of rows. What I need to know is how to select the range of cells corresponding to the ones above. E.g. I have a range "myRange" which refers to:…
Karl
  • 5,573
  • 8
  • 50
  • 73
0
votes
2 answers

Excel VB: add Cell to existing Name

I'm trying to add a Cell to an existing Name via VB. My best Attempt looks like this: Tabelle1.Names("delCase").RefersTo = Tabelle1.Names("delCase").RefersTo + ";" + Target.Address But this prompts a Application- or objectdefined Error
Blank Chisui
  • 1,043
  • 10
  • 25
1 2 3
…
40 41