Top "Named-ranges" questions

A named range is a defined area, typically in a spreadsheet or document, used for future reference.

How do I reference a cell within excel named range?

For example, I have a named range A10—A20 as Age; how do I get Age[5] which is same as …

excel excel-formula named-ranges
Using named cells in a VBA function

I have a worksheet where I have defined names for certain cells. These cells will be used in the function …

function vba named-ranges
VBA- Find location of first cell in named range to reference heading row of spreadsheet

What I have is part descriptions that I have split into separate columns. All columns have headings, but not all …

excel vba concatenation named-ranges
Referencing Dynamic Named Range in Excel Formula

I have a table in Excel with column headings that correspond to part of a dynamic named range elsewhere in …

excel dynamic excel-formula named-ranges
Google Spreadsheet range names

In Google Docs Spreadsheets, one can use Range Names to put labels on ranges of cells to make formulas more …

google-sheets named-ranges
getRange with named range google spreadsheet using scripts

Can the getRange be used to have a named range instead of an area? When I seem to do it, …

google-apps-script google-sheets named-ranges
How do you get a Range to return its Name?

Dim sampleRange as Range Set sampleRange = Worksheet.Range(Cells(1,1),Cells(1,4) sampleRange.Name = "Range1" MsgBox sampleRange.Name The above code will …

excel vba named-ranges
excel named range copy from sheet to sheet

I have an Excel question, I am wondering if there is an easy way to set up a clone or …

excel named-ranges
Generate a filtered, dynamic drop down list

I need two dynamic drop down lists for data validation. One containing a unique list of continents to choose from, …

excel dynamic excel-2007 validation named-ranges
Populate list box with a named range

I'm working on my first ever VBA project, and need a bit of absolute newbie guidance. I have a submission …

vba excel listbox named-ranges