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

Excel VBA - Function to check a specific sheet and named cell exists in workbook

I have a sub which opens an older version of a checklist I've created, and then imports the data. After the user selects the file, I want to check if a specific sheet and named cell on that sheet exists (for validation they have picked the correct…
mattfeeder18
  • 27
  • 8
2
votes
1 answer

Loop through all Cells in a Row and a Named Range Simultaneously

Apologies up front, I'm a VBA novice. I'm looking to to find a way where I can loop through all cells in a row and if the cell is a part of a named range "Targets", I have the background colour change. I have originally done this using the code…
Hooksta_v1
  • 25
  • 2
2
votes
1 answer

Name Object Returning SheetName

I am trying to loop through all my Named Ranges and set them as a string if they contain a certain substring using a wildcard operator and LIKE. Finding the correct Named Range is working as it should. However, when I set the string to the name of…
Reece Edwards
  • 89
  • 2
  • 9
2
votes
2 answers

Get a Named Range as a Collection in Blueprism

The BluePrism Excel VBO has Get Worsheet As Collection and Get Worksheet Range as Collection actions, but as an experienced VBA developer, I know it is better to refer to to named ranges. (It makes you less vulnarable to rearangements of the…
Dirk Horsten
  • 3,753
  • 4
  • 20
  • 37
2
votes
2 answers

VBA List of Hyperlinks for Named ranges in Workbook

I am trying to create VBA code that identifies named ranges in my workbook and creates a hyperlink for each. These hyperlinks need to be capable of being copied to other documents. I found two examples--each one does half of the job, but am having…
Learner
  • 21
  • 2
2
votes
1 answer

Issue referencing a named range in a worksheet formula

I'm having some issues using named ranges in formulas in excel from Microsoft Office 365 Business. This is something that I used to do constantly a few years ago, but now I stumped as to what I'm doing wrong... I'm assuming some functionality has…
Sam Gilbert
  • 1,642
  • 3
  • 21
  • 38
2
votes
1 answer

Excel - Is there a possibility to offset an array of ranges?

Basically I have defined mydata = {$E$2:$H$6,$J$2:$M$6,$O$2:$S$6,$V$2:$Y$6,$AA$2:$AE$6,$AG$2:$AJ$6,$AM$2:$AP$6, $AR$2:$AV$6,$AX$2:$BA$6,$BD$2:$BG$6,$BI$2:$BM$6,$BO$2:$BR$6} this array of ranges. Is there a way to offset(mydata,x,y) ? Context:…
Tudor Corneliu
  • 21
  • 1
2
votes
1 answer

'Error 380: Could not set the RowSource property. Invalid Property value' for Excel user form to import data from Access to Excel

I am using Excel 2013 in Windows 7. I’ve created a userform in Excel, using VBA in Excel to import data from Access into Excel after clicking a button per onlinepclearning(dot)com/append-and-delete-ms-access-record-sets-from-an-excel-userform/.…
sturdy267
  • 79
  • 1
  • 14
2
votes
1 answer

Dynamic ranges again - once more, with text strings

I have a series of data sets (later to be used for populating comboboxes), and I've tried setting up dynamic ranges to list only the cells with useful data. In total, there are 160 rows of data, but the number of rows that will be populated will…
Andrew Perry
  • 743
  • 2
  • 11
  • 32
2
votes
1 answer

Using range names as cell source

I've been trying to work on this thing in OpenOffice Calc, where I have two drop lists in a spreadsheet, in which data is coming from other columns. I've attached a snapshot for better understanding. Cells A1-A3 are represented by named-range…
IshanAg24
  • 199
  • 2
  • 11
2
votes
2 answers

Why is my "defined name" (range) value not being set with this Spreadsheet Light code?

I've got this code to apply a "header" (big, top-of-the-sheet "title") to a sheet: // Initialize private static SLDocument sl; . . . sl = new SLDocument(); // Create a Style SLStyle styleHeading =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
2
votes
2 answers

Excel VBA. How do you get a specific name associated with a range?

I have a cell that has more than one named ranges associated with it. How do I get it to return a specific name without having to loop through all the names in the workbook? Sub Test() ActiveWorkbook.Names.Add Name:="AUserDefinedName1",…
ptownbro
  • 1,240
  • 3
  • 26
  • 44
2
votes
1 answer

remove duplicates in named range

i have a problem which i believe you will find a simple solution i am over my head with this one I have code that copies a range from another workbook, pastes it in the current workbook, and then removes the duplicates Problem is, after removing the…
CORNAKI
  • 77
  • 2
  • 8
2
votes
2 answers

Excel: Vlookup in named range and return a value outside of range

I need to find a way to search for a value in a named range and to return the column next to that range. The reason is simple: I do use list validation with a named range in column A. In this list there are complete name of product types (ex. Relay,…
Outline
  • 63
  • 1
  • 8
2
votes
1 answer

Using FIND function to return last value in VBA

I am trying to write a function which searches through a column and return the cell which contains the last match. For example, if I have cell A5 as my active cell A1 -> Text A2 -> wefwqef A3 -> Text A4 -> eorbebr I would want to search through the…
Cheves
  • 21
  • 1
1 2 3
…
40 41