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.

Please Login or Register  to view this content.

**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.

Please Login or Register  to view this content.

How to assign variable when adding Name?

LinkBack

Thread Tools

Rate This Thread

Display

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