How do you use the Name property of the Range object?

[Excel_vba]

I am trying to assign a name to a range:

Please Login or Register  to view this content.

I am getting an error saying "Object doesn't support this property or method."



I have two questions:

1. How do you assign a name to a range?
2. How do you display that name in a Msgbox?

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Richard Buttrey]

Hi,

1.
worksheets(1).Range("D4:D8").Name = "Revenue"

2.
MsgBox Range("D4:D8").Name.Name

[TMS]

Not sure if this is what you mean for the second part:

Please Login or Register  to view this content.

Regards, TMS

[Excel_vba]

Hi,

1.
worksheets(1).Range("D4:D8").Name = "Revenue"

2.
MsgBox Range("D4:D8").Name.Name

Thank you sir. I'm fairly certain I tried your suggestion for #1, but it didn't work. But it works fine now.
Regarding #2, it works but the MsgBox says Sheet1!Revenue instead of simply Revenue. Is there a way to display just Revenue?

[Excel_vba]

Thank you sir. I'm fairly certain I tried your suggestion for #1, but it didn't work. But it works fine now.

I tried this with a two word name and got an error. But then I remember that a space isn't allowed in a Name. You need an underscore.

[Richard Buttrey]

Re 2.

Seems to work OK for me. Upload your workbook if it's still not showing just Revenue.