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

Named ranges won't work

Whenever I try to make a named range in Excel I keep getting an error. I believe my formula is correct: =OFFSET($B$2,0,0,COUNTA($B$2:$B$200),1) However when I press OK I keep getting the dialog screen which states Excel found a problem with my…
Sjoerd
  • 1
0
votes
1 answer

Loop through Named Ranges with Dates, Calculate difference on 3rd column

I have an Excel sheet that has 2 dynamic named range for user to input starting dates and ending dates. I would like VBA to check that when user enter starting date and ending date, calculate the difference and have the result shown on 3rd…
Albert Sim
  • 1
  • 2
0
votes
0 answers

Excel calculations across many tabs with many formulas and named ranges

I have a massive Excel Workbook and I am having problems with some of the formula calculations that make use of custom VBA functions and Named Ranges. The workflow for the workbook is a bunch of calculations on Tab 1, that then filter to…
wh4tshisf4c3
  • 133
  • 12
0
votes
1 answer

Using Named Range as single cell references in formulas that accept arrays

So background first, question second. I recently discovered an interesting property of named ranges that I'm experimenting with and not finding much help. The property is this: If I name a range (a column in this example), I can use the named range…
user4802802
0
votes
0 answers

Matlab: Write table to Excel (using named range)

writetable(myTable,'myFile.xlsx','Sheet','Matlab','Range','A2', 'WriteRowNames', 1); It seems that if I replace 'A2' by a Named Range, this function does not work. writetable(myTable,'myFile.xlsx','Sheet','Matlab','Range','myRange',…
serge
  • 313
  • 4
  • 14
0
votes
1 answer

Can a Defined Name in a cell provide the data source for a PivotTable?

I have several tables of data and I've named them. I'd like to create one PivotTable and be able to key the name of a data range into a cell and have the PivotTable reference the range named in that cell. For example, if I could have the PivotTable…
ciso
  • 2,887
  • 6
  • 33
  • 58
0
votes
3 answers

Storing range reference in a global variable

I'm using several named ranges located in different worksheets. I need to read from and write to those ranges in many situations throughout my VBA code. So my question is: what is the proper way to store those range references in global variables…
ttaaoossuuuu
  • 7,786
  • 3
  • 28
  • 58
0
votes
1 answer

VBA Passing a Range Name from a Different Worksheet to a Function

Maybe I'm trying to do too much here, but I've worked for hours on this with no luck. I hope you can help. I am creating a function whose only parameter is a named range on a another sheet in the same workbook. My problem is that I can't figure out…
Richard
  • 11
  • 7
0
votes
1 answer

Excel - Refresh and Validate Data From SQL (VBA)

I'm using office 2013 and SQLServer 2008 R2. I have an Excel VBA proc that inserts a list of commissions for sales into a database. One of the columns is SalesRepID, which clearly has to be valid. When it was written, we had a fairly static sales…
mark1234
  • 1,110
  • 2
  • 24
  • 41
0
votes
1 answer

Excel Search for cell match in multiple named ranges

I have a series of named ranges on a tab stored with the top row serving as each range's name (eg fruit, apple, pear, apricot). There are empty columns between each list. On a different tab I have a column "Description" which has data values that…
Jason
  • 1
  • 1
0
votes
1 answer

Excel Array Formula in Named Range to Return List of Sequential Numbers

I would like to use an array in the formula of a Named Range to return a list of sequential numbers. So instead of having a list of numbers on an actual worksheet, they are produced by an array formula and stored in a Named Range to be used as a…
user2966988
0
votes
2 answers

Name Manager using VBA - Macro vs. Function Call Gives Different Response

I have an XLA I'm use to make calculations and I'd like to create variables in the Name Manager to use in those calculations. I want to check to see if those named ranged already exist and if not let the user assign values to them. I have a Sub()…
Bryan
  • 3
  • 1
  • 3
0
votes
3 answers

Userform Listbox to select a named range

I've got a set of named ranges on a worksheet which hold summary data from other tabs (one for each month). The ranges are named JAN / FEB / MAR etc. My file contains various reports which compare one month with another and to make this dynamic I…
Lemon
  • 1
  • 1
  • 2
0
votes
0 answers

Google Apps Script - How to get A1 Notation of a range when you don't know the length

I'm sure there is a simple way to do this but I'm spinning wheels trying to figure it out. I have several columns, each of different lengths. I would like to get the A1 notation for each of them, minus a header. I get the index number of the column…
RossV
  • 195
  • 3
  • 12
0
votes
1 answer

Total multiple columns for multiple teams & groups

I need to total the teams A B C D for Girls & Boys However the order of the teams changes each week, so I can not do a simple: GIRLS TEAM A = B3+G3 GIRLS TEAM B = C3+H3 A B C D E F G H I 1 Saturday Sunday…
LOUISE
  • 1
1 2 3
…
40 41