Tag: named-ranges

8 What's the difference between a Table and a Named Range in Excel 2007? 2010-04-07T14:54:50.063

8 Shortest Method To Reference A Single Row/Column of a Named Range in Excel? 2010-06-24T19:54:07.520

5 How do I prevent VLOOKUP from breaking after I add a column to a named range? 2011-08-11T18:07:20.020

4 Excel reference named range with text and formula 2013-08-25T14:03:06.023

4 Apply Names in Excel is bugged? 2015-05-25T21:55:52.170

3 Excel Name.RefersToRange: how to check if Name object refers to a range? 2011-11-03T17:07:52.830

3 Creating a chart using a dynamic named range in Excel 2010 2012-08-20T18:16:37.197

3 Excel 2010: Create named range without a sheet reference in the formula 2015-06-19T19:17:20.960

3 Single named range over multiple sheets in same Excel file? 2017-06-29T18:20:19.313

2 How do you make the Named Ranges box bigger in Excel? 2010-08-09T20:12:05.013

2 Mac Excel 2011: find Items in one column that are not in another column 2012-09-24T12:22:52.773

2 Can the name of a named range be dynamic? 2013-11-27T15:49:11.610

2 Referencing cell only by column name in Excel 2010 VBA 2015-02-09T22:33:11.787

2 Build a lookup query in Excel using named ranges stored in a cell 2015-10-12T22:45:22.870

2 compare text to named range in external sheet 2016-05-11T18:09:24.587

2 Converting/transforming sum(A1:D1) into A1+B1+C1+D1 in Excel 2017-04-07T05:06:09.830

1 How exactly do I create "Dynamic Named Ranges"? 2011-09-19T13:26:18.437

1 Count from a certain cell until a blank cell 2013-07-25T08:41:31.070

1 Fill formula containing named range but change named range based on relative reference 2013-08-22T09:30:40.940

1 Get the row and column for a cell in a named range? 2014-01-03T04:49:37.550

1 Insert columns, within a range, based on cell reference 2014-01-15T09:42:29.567

1 Creating Dynamic, Unique Arrays Dependent on Multiple Criteria or Subset of Data 2014-07-16T23:59:42.657

1 How can I check that a filter applied to a listobject column with vba is legal? 2014-10-01T22:55:48.690

1 One dynamic named range not staying dynamic while another in the workbook is 2015-04-24T22:57:19.720

1 When using a named ranged in Excel (2013), how to display the entire range, but offset one cell? 2015-08-05T17:50:58.690

1 Referencing a dynamic, named range between workbooks 2016-08-01T21:15:59.240

1 Excel 2010 vbs, creating a named range causes an Update Values dialog box to appear 2017-02-27T22:37:10.210

1 Using Table name in vlookup for conditional formatting 2017-07-10T19:06:58.983

1 Can VBA delete named ranges based on RefersTo value? 2017-07-21T12:57:32.563

1 VBA - How to refer a closed workbook named range 2019-02-12T11:10:53.613

1 Excel telling me my name already exists when renaming a table 2019-02-18T14:19:08.830

1 Excel - named range in a conditional formatting formula 2019-04-05T18:18:08.250

1 How to Create Named Range in VBA with Formula (Run-time error 438) 2019-07-02T21:11:50.407

1 Split Range by other Range between it? VBA 2019-07-26T12:29:25.197

1 Excel named lists, concatenating results 2019-11-28T14:55:28.397

0 How to call a namer range using a variable to define the name 2014-02-08T01:30:57.747

0 Defined Name to give text or date value instead of numeric value 2014-04-01T02:21:59.217

0 Calculating Named Ranges 2014-06-19T14:45:12.267

0 How to create multiple named ranges with a fixed size from one column? 2015-01-13T20:46:51.930

0 Auto-increment cells for named rows and named columns 2015-01-13T22:20:03.837

0 Copy named ranges to another workbook 2015-04-09T14:54:26.557

0 How to transpose a named range in Excel 2013, using cell formulas (not VBA) 2015-08-05T19:34:39.723

0 How to get a list of all named ranges in calc 2016-04-13T04:47:13.227

0 using named ranges in a sumif formula 2016-06-21T20:12:59.067

0 Excel VBA: Create two-dimensional array from multiple named ranges(no duplicates), sum columns 2016-08-22T06:05:06.970

0 Excel spreadsheet (2010 of 2013) 2016-10-18T20:22:06.767

0 Excel: Named Ranges based on cell Values 2017-03-29T08:34:00.583

0 trigger a macro by clicking on merged range 2017-07-14T20:38:44.197

0 In Excel, can I create a name that refers to cells that aren't tied to one worksheet? 2018-03-09T10:44:14.943

0 Cell "address" function for entire reference range 2018-03-20T02:48:15.207

0 Excel: How to replace references to named ranges with other named ranges that have the same name 2018-03-29T18:59:59.840

0 Find value in a non-continuous range in Excel 2018-05-09T06:13:03.903

0 How to create dynamic named range that includes blank cells? 2018-08-14T14:00:14.280

0 How to convert names created with Excel's Name Box from workbook-scoped to worksheet-scoped? 2019-06-27T03:16:29.223

0 Three dimensional named ranges for dynamic graph 2019-08-07T11:33:04.643

0 Varying Chart Range Based on Drop Down Lists 2019-08-13T14:14:37.107

0 Dynamic filtered named range in Excel? 2019-12-12T18:31:14.773

0 Excel: Why "some" named ranges in copied Worksheet Refers to: old WB reference 2019-12-14T02:24:04.900

0 How to Copy Excel Named Range? 2020-02-27T06:19:54.297

-1 Excel 2010: How do I reference a specific field using a defined column name and a row number? 2014-10-28T20:36:26.663