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
2
votes
1 answer

Google spreadsheet - Error when Remove range protection

Here's my script, but I can't get it to work for some weird reason??!!! Driving me nuts. function removeThenSetProtection() { // Remove all range protections in the spreadsheet that the user has //permission to edit. var ss =…
Sean Sugden
  • 23
  • 3
2
votes
1 answer

AVERAGEIFS does not work, but AVERAGE(IF( does

We have a large spreadsheet that we use to calculate performance for race car drivers. It has been stable for quite some time. Today, I opened it and found that one of the tables was not calculating correctly. I tried recalculating the sheet (it…
RSR_john
  • 51
  • 1
  • 6
2
votes
3 answers

Return a value from a Named Range/Formula (ERROR 1004, 2015, or 13)

I am having trouble returning a value from a Named Formula in Excel VBA (a simple Named Range works as expected). Steps to Recreate Blank workbook Create the Named Range/Formula rowOffset equal to: =ROW(Sheet1!$A$2)-ROW(Sheet1!$A$1) rowOffset…
Rick
  • 43,029
  • 15
  • 76
  • 119
2
votes
1 answer

Create chart title from sheetname

I am hoping to amend my charts using VBA I have created a Named Range using formula, named it SheetNames =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"") Then in VBA, I was trying to change the chart title: ActiveChart.HasTitle =…
jw0ng
  • 91
  • 4
  • 11
2
votes
1 answer

EXCEL 2010 Build a chart based on a named range that may move

I'm struggling to find a solution to something I thought would have been simple. In a separate app, I'm copying an Excel workbook, running a bunch of database queries and dumping the result into the newly copied workbook, giving each result a…
Alan Schofield
  • 19,839
  • 3
  • 22
  • 35
2
votes
1 answer

Excel VBA to Pull Non-Null rows from another workbooks named range

New to the site with weak VBA skills. Hoping I can find some assistance with something I have been struggling with for days. I have found many examples that are close, and cant seem to marry them together. I am using Excel 2007. I have a…
user2708252
  • 21
  • 3
2
votes
4 answers

In Excel 2007, how can I SUMIFS indices of multiple columns from a named range?

I am analysing library statistics relating to loans made by particular user categories. The loan data forms the named range LoansToApril2013. Excel 2007 is quite happy for me to use an index range as the sum range in a…
Shimmin
  • 21
  • 1
  • 1
  • 2
1
vote
1 answer

Excel Delete row if in named range

I have a worksheet with protected cells. There's an 'add row' button and I need a 'delete row' button. HOWEVER, I only want the user to be able to delete the row if it is within a named range. ActiveSheet.Unprotect Password:="password" If…
Steamroller60
  • 25
  • 1
  • 6
1
vote
0 answers

What exactly happens when Named Ranges is created or removed in Google App Scripts?

When I duplicated a sheet with already defined Named Ranges (say NamedRange), the new sheet's (NewSheet) Named Ranges automatically created the new Named Ranges as: NewSheet!NamedRange_conflict425783334. Renaming the new sheet (From NewSheet to…
Aashit Garodia
  • 330
  • 1
  • 11
1
vote
1 answer

Loop creating Run-Time error 1004 but cannot figure out why....loop uses named ranges to adjust charts

I have a worksheet with about 500 charts in excel. I created them manually, 1 at a time, over many hours. All of the charts rely on named ranges to define their series. All of the named ranged are being pulled from the same sheet, namely, the…
BHF
  • 35
  • 7
1
vote
2 answers

Convert from ParamArray to cells/range

I'm working on the macro below, that will allow the user to feed it multiple ranges, and it will restore the default for each cell in each range. The problem comes when I try to loop through each of the ranges, I need to use a variant "vI as…
Dumitru Daniel
  • 571
  • 4
  • 19
1
vote
1 answer

VBA: How do you see if a cell value matches a worksheet name? Run-time error '1004'

Sub searchBoys() 'profile is the name being searched Dim profile As String Dim ws As Worksheet profile = LCase(Sheet8.Range("searchName").Value) For Each ws In ActiveWorkbook.Worksheets If profile = Trim(LCase(ws.name)) Then ws.Select …
nick
  • 11
  • 2
1
vote
0 answers

Conditional formatting with dynamic named ranges

I'm trying to optimize my conditional formatting in google sheets to improve my overall spreadsheet performance. One thing I've read to improve spreadsheet performance in general, is to use closed ranges (ex $A$3:$A$450) rather than ranges (ex…
rachel
  • 25
  • 6
1
vote
1 answer

In excel, can you create a named range from multiple values (linestring) within a single cell?

I was wondering if I can make a named range from a linestring in a single cell, like "1,2,3,6,7" or "1-3, 6-7", instead of having to type each value in its own cell. In column C of sheet A, I want to sum the values of column B if the values of…
Peter W
  • 11
  • 3
1
vote
1 answer

How to create a NamgedRange using google sheets API when doing a batch update with Go

I recently started writing a program to export CSV and SQL to google sheets. And in some scenarios I need to create a NamedRange while creating the sheet and/or updating it. The google official documentation is kinda confusion and not very helpful…
VandrerenErik
  • 13
  • 3
1 2 3
…
40 41