VBA for named range where the name of the range is dependent on cell input

**pnegi** · 08-26-2015, 07:02 AM

Hi, need some help on named range VBA.

I want to have a name range where the name of the range is dynamic basis input in cell, let us say sheet 1 cell "B10".

The value of the named range is in Sheet 1 cell "F10".

Could someone kindly help? thanks in advance.

**davesexcel** · 08-26-2015, 07:18 AM

Sub Button1_Click()
    Dim rng As Range
    Set rng = Sheets("Sheet1").Range("F10")
    On Error GoTo er
    Sheets("Sheet1").Range("B10").Name = rng.Value
    Exit Sub
er:     Sheets("Sheet1").Range("B10").Name = "NoName"

End Sub

VBA for named range where the name of the range is dependent on cell input

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA for named range where the name of the range is dependent on cell input

Re: VBA for named range where the name of the range is dependent on cell input

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Assign named range to one cell depending on named range in another

dependent listbox with named range

[SOLVED] determining if cell is part of named range and what that named range is

Dependent, Dynamic Named Range with Multiple Criteria

[SOLVED] Can't use Numbers in named range list for Dependent data validation lists

Ignore blank cells in a named range when using dependent data validation

Dependent Validation -- How can I enter information that is not in a named range?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions