How to assign variable when adding Name?

**sunnyschindler** · 08-22-2023, 01:08 AM

Is it possible to assign variable when adding name?
following code no longer compile after I added "set nm = "
I am using assigned variable for Debug.Print added name.

        
dim nm as name
Set myNamedRange = .Range("D1:E10")    
        '// specify defined name
        myRangeName = "namedRangeWSscope"
        '// create named range with worksheet scope. 
       set nm =  myWorksheet.Names.Add Name:=myRangeName, RefersTo:=myNamedRange

**ByteMarks** · 08-22-2023, 04:45 AM

It's not clear which sheet .Range("D1:E10") refers to and myWorksheet is undefined.

Maybe this is what you're looking for.

Sub Test()
Dim nm As Name
Dim myWorksheet As Worksheet

Set myWorksheet = Sheet1
With myWorksheet
    Set myNamedRange = .Range("D1:E10")
    '// specify defined name
    myRangeName = "namedRangeWSscope"
    '// create named range with worksheet scope.
    Set nm = myWorksheet.Names.Add(Name:=myRangeName, RefersTo:=myNamedRange)
End With
End Sub

How to assign variable when adding Name?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to assign variable when adding Name?

Re: How to assign variable when adding Name?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] User defined type: assign a variable to another variable

[SOLVED] How to extract a piece of a string variable, and assign to a new variable

[SOLVED] Assign entire row to variable, how do you paste variable values in a new workbook?

Adding a variable string comment to a cell. "Object Variable or WIth Block Variable Not.."

[SOLVED] Assign a variable a cell number based off off another variable that is assigned a cell num

Assign value to a variable name

Assign value to variable

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions