named range - Search Results - Excel Help Forum

Data Validation Gives Error When Referencing a Named Range

Started by acroley1‎, 05-19-2025 05:20 PM

data validation, data validation list, dynamic drop down list, excel 365, named range

6

183

Last Post By:: Last Post: 05-20-2025 08:03 AM; by wk9128

Forum:
Excel Formulas & Functions

Named Range Results in Spill Error

Started by gnulab‎, 11-17-2024 01:24 AM

6

443

Last Post By:: Last Post: 11-17-2024 06:13 AM; by AliGW

Forum:
Office 365

[SOLVED] Combo Boxes with multiple named ranges?

Started by Djeuve‎, 07-24-2024 06:46 PM

8

564

Last Post By:: Last Post: 07-27-2024 02:02 AM; by AliGW

Forum:
Excel Programming / VBA / Macros

Nesting Named Ranges and Hiding/Revealing Rows based on User Input/Drop-Downs

Started by roccasar‎, 10-25-2023 02:58 PM

excel, excel & drop downs, named range, vba, vbamacro

0

312

Last Post By:: Last Post: 10-25-2023 02:58 PM; by roccasar

Forum:
Excel Programming / VBA / Macros

[SOLVED] Creating named-ranges in Excel automatically using formula (or VBA)?

Started by JMB99‎, 10-23-2023 02:16 PM

excel, excel formula how to, named range

5

458

Last Post By:: Last Post: 10-25-2023 06:45 AM; by JohnTopley

Forum:
Excel General

Unable to delete some names in named range

Started by sbhatexcel‎, 10-02-2023 10:10 AM

1

307

Last Post By:: Last Post: 10-02-2023 10:12 AM; by AliGW

Forum:
Excel Programming / VBA / Macros

[SOLVED] Alternative to INDIRECT for referencing Named Ranges

Started by hamsuke‎, 09-08-2023 01:47 AM

8

410

Last Post By:: Last Post: 09-08-2023 11:14 AM; by TMS

Forum:
Excel Formulas & Functions

Get a list of words consisting of certain letters only, from a named range

Started by Tresfjording‎, 08-25-2023 04:45 AM

criteria, ecstract, named range, strings

26

765

Last Post By:: Last Post: 08-25-2023 10:05 PM; by AliGW

Forum:
Excel General

How to assign variable when adding Name?

Started by sunnyschindler‎, 08-22-2023 01:08 AM

add, assign a variable, compile error, excel vba, named range

1

391

Last Post By:: Last Post: 08-22-2023 04:45 AM; by ByteMarks

Forum:
Excel Programming / VBA / Macros

Formula for a SUMIF or SUMIFS with summary and value in different worksheets

Started by Hedy‎, 08-18-2023 04:42 PM

different worksheets, named range, sumif, sumifs

4

398

Last Post By:: Last Post: 08-18-2023 06:34 PM; by TMS

Forum:
Excel Formulas & Functions

Need sheet A to automatically copy just values/formatting of sheet B when changes are made

Started by OBrienMechanicalEng‎, 07-26-2023 10:01 AM

excel, named range, revit, schedule xl, vlookup

9

476

Last Post By:: Last Post: 07-27-2023 02:30 PM; by ByteMarks

Forum:
Excel Programming / VBA / Macros

[SOLVED] VBA to create Named References to Spilled Ranges

Started by truk2‎, 06-05-2023 03:16 AM

dynamic arrays, named range, spilled range, vba

2

428

Last Post By:: Last Post: 06-05-2023 10:17 PM; by truk2

Forum:
Excel Programming / VBA / Macros

[SOLVED] Sum if named range begins with

Started by aurelien_21‎, 05-01-2023 05:17 AM

8

676

Last Post By:: Last Post: 05-03-2023 11:18 AM; by JohnTopley

Forum:
Excel Formulas & Functions

Restrict data entry in Drop Down List based on a Named Range

Started by Snick77‎, 01-13-2023 03:27 PM

data validation, drop down list, named range

4

709

Last Post By:: Last Post: 01-25-2023 03:14 PM; by Snick77

Forum:
Excel General

[SOLVED] How can I edit an existing named range scoped to the workbook

Started by Paul Newton‎, 12-23-2022 02:01 PM

6

385

Last Post By:: Last Post: 12-23-2022 03:29 PM; by TMS

Forum:
Excel Programming / VBA / Macros

Un-naming named ranges

Started by mpittard‎, 12-19-2022 01:40 PM

2

395

Last Post By:: Last Post: 12-19-2022 02:55 PM; by mpittard

Forum:
Excel General

[SOLVED] Error trying to use a named range to define series x values

Started by Paul Newton‎, 12-19-2022 09:50 AM

9

373

Last Post By:: Last Post: 12-19-2022 11:47 AM; by TMS

Forum:
Excel Programming / VBA / Macros

Named Range using Dynamic Range

Started by TeacherWart‎, 12-11-2022 05:28 PM

10

518

Last Post By:: Last Post: 12-12-2022 04:49 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

[SOLVED] Can't delete named ranges - linking to other file

Started by utm1996‎, 12-08-2022 11:14 AM

1

311

Last Post By:: Last Post: 12-08-2022 11:28 AM; by utm1996

Forum:
Excel Programming / VBA / Macros

Simple vba FUNCTION that uses NAMED RANGES

Started by whburling‎, 11-30-2022 05:19 PM

function, named range, parameters, subroutine, udf

17

1,748

Last Post By:: Last Post: 12-01-2022 07:18 PM; by TMS

Forum:
Excel Programming / VBA / Macros

Redefining Named Ranges in a Table

Started by TheRazor‎, 07-11-2022 04:42 PM

1

629

Last Post By:: Last Post: 07-12-2022 09:38 AM; by oeldere

Forum:
Excel General

Named file folder range live updated and sorted

Started by Retroshift‎, 05-18-2022 11:13 AM

0

356

Last Post By:: Last Post: 05-18-2022 11:13 AM; by Retroshift

Forum:
Excel Formulas & Functions

Paste data in named range

Started by max138‎, 05-13-2022 10:09 AM

1

419

Last Post By:: Last Post: 05-13-2022 06:32 PM; by dflak

Forum:
Excel General

Make data validation display values from one column and store values from another

Started by pluginguin‎, 04-11-2022 04:01 AM

13

651

Last Post By:: Last Post: 04-14-2022 06:53 AM; by JohnTopley

Forum:
Excel Formulas & Functions

[SOLVED] Sparklines with dynamic (named) range not working

Started by fexofenadine‎, 03-20-2022 12:41 AM

dynamic cell reference, dynamic range, named range, sparkline, sparklines

3

1,307

Last Post By:: Last Post: 03-20-2022 05:29 PM; by fexofenadine

Forum:
Office 365

[SOLVED] Countif with multiple criteria

Started by Littlesimon‎, 02-10-2022 02:13 AM

7

663

Last Post By:: Last Post: 02-11-2022 12:14 AM; by Littlesimon

Forum:
Excel Formulas & Functions

Deleting Broken Defined Name

Started by polishfc‎, 01-21-2022 06:25 PM

define cell names, define range, name manager, name ranges, named range, out of memory, vba

5

678

Last Post By:: Last Post: 01-23-2022 07:28 AM; by Glenn Kennedy

Forum:
Excel Programming / VBA / Macros

Google Sheets - Combine VLOOKUP with Named Ranges to create Drop Down

Started by antonyx‎, 01-16-2022 09:50 AM

data validation, google sheets, named range, vlookup

2

653

Last Post By:: Last Post: 01-16-2022 10:39 AM; by antonyx

Forum:
For Other Platforms(Mac, Google Docs, Mobile OS etc)

[SOLVED] My formula is not changing a 'month' when using named range

Started by rayted‎, 01-11-2022 10:08 AM

1

342

Last Post By:: Last Post: 01-11-2022 10:56 AM; by Bo_Ry

Forum:
Excel Formulas & Functions

[SOLVED] How to use named range in a formula?

Started by mstgier‎, 01-03-2022 04:44 AM

12

472

Last Post By:: Last Post: 01-03-2022 05:14 AM; by mstgier

Forum:
Excel Formulas & Functions

Using a named range ARRAY inside an OFFSET function

Started by James McEwan‎, 11-22-2021 02:49 PM

2

553

Last Post By:: Last Post: 11-22-2021 03:36 PM; by James McEwan

Forum:
Excel Formulas & Functions

[SOLVED] Dynamic Named Range formula with Indirect and Index for Chart

Started by wmfinn001‎, 10-13-2021 01:18 PM

chart, dynamic range, index, indirect, named range

4

956

Last Post By:: Last Post: 10-13-2021 03:14 PM; by protonLeah

Forum:
Excel Charting & Pivots

Using named range cells

Started by mlsexcel2021‎, 09-29-2021 05:29 PM

3

402

Last Post By:: Last Post: 09-29-2021 06:43 PM; by TMS

Forum:
Excel Programming / VBA / Macros

[SOLVED] VBA to copy Named Ranges

Started by LKERN‎, 09-23-2021 10:37 AM

named range, named range list, vba & excel

14

810

Last Post By:: Last Post: 09-25-2021 05:43 PM; by LKERN

Forum:
Excel Programming / VBA / Macros

Creating a Dynamic Pareto Chart

Started by agpuh‎, 07-28-2021 11:42 AM

5

997

Last Post By:: Last Post: 08-23-2021 11:35 AM; by JeteMc

Forum:
Excel Charting & Pivots

Search:

Search: Replies Views Search took 0.00 seconds; generated 36 minute(s) ago.

Data Validation Gives Error When Referencing a Named Range

Named Range Results in Spill Error

[SOLVED] Combo Boxes with multiple named ranges?

Nesting Named Ranges and Hiding/Revealing Rows based on User Input/Drop-Downs

[SOLVED] Creating named-ranges in Excel automatically using formula (or VBA)?

Unable to delete some names in named range

[SOLVED] Alternative to INDIRECT for referencing Named Ranges

Get a list of words consisting of certain letters only, from a named range

How to assign variable when adding Name?

Formula for a SUMIF or SUMIFS with summary and value in different worksheets

Need sheet A to automatically copy just values/formatting of sheet B when changes are made

[SOLVED] VBA to create Named References to Spilled Ranges

[SOLVED] Sum if named range begins with

Restrict data entry in Drop Down List based on a Named Range

[SOLVED] How can I edit an existing named range scoped to the workbook

Un-naming named ranges

[SOLVED] Error trying to use a named range to define series x values

Named Range using Dynamic Range

[SOLVED] Can't delete named ranges - linking to other file

Simple vba FUNCTION that uses NAMED RANGES

Redefining Named Ranges in a Table

Named file folder range live updated and sorted

Paste data in named range

Make data validation display values from one column and store values from another

[SOLVED] Sparklines with dynamic (named) range not working

[SOLVED] Countif with multiple criteria

Deleting Broken Defined Name

Google Sheets - Combine VLOOKUP with Named Ranges to create Drop Down

[SOLVED] My formula is not changing a 'month' when using named range

[SOLVED] How to use named range in a formula?

Using a named range ARRAY inside an OFFSET function

[SOLVED] Dynamic Named Range formula with Indirect and Index for Chart

Using named range cells

[SOLVED] VBA to copy Named Ranges

Creating a Dynamic Pareto Chart