VB.NET - Delete 'Named Range' of Activecell

Question

I'm trying to write a code to using VB.Net to delete the Named Range of the activecell. I can't seem to figure out the correct syntax for this. Can someone please help?

        Dim xlApp As Excel.Application

        xlApp = GetObject(, "Excel.Application")

        xlApp.ActiveCell.Name.Name.Delete()

Thanks in advance.

TnTinMn · Accepted Answer · 2021-03-07 15:35:41Z

2

The Application.ActiveCell property returns a Range object.

The Range.Name property returns a Name object.

The Name.Name property returns a string.

So, the statement:

xlApp.ActiveCell.Name.Name.Delete()

is trying to call the nonexistent Delete method on a string.

The statement should be:

xlApp.ActiveCell.Name.Delete()

to call the Name.Delete method.

answered Mar 7, 2021 at 15:35

TnTinMn

11.8k3 gold badges21 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Patrick Over a year ago

Thank you @TnTinMan for helping me with this. Much appreciated.

Collectives™ on Stack Overflow

VB.NET - Delete 'Named Range' of Activecell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related