Question about the Excel object model

[Caze982]

Hi everyone

I am trying to learn about the Excel object model and i am bit confused the following code line:

Excel.Application.Selection.CurrentRegion.Select

In the object browser i can see that application is an child class and a property of Excel. I can also see the selection is a property of the application class. But how can i in the object browser see that currentRegion is a property of selection?

Sincerly
Christian

 

[Kyle123]

In that context Selection returns a Range object and CurrentRegion is a property of the Range object.

 

[Norie]

Christian

CurrentRegion is a property of the Range object and it's more than likely Excel.Application.Selection is returning a Range object, if it isn't then you'll get a runtime error.

 

[Caze982]

Hi Norie

Thank you for your reply, do you know of a way where i can see that Excel.Application.Selection is returning a range object?

 

[Caze982]

Hi Kyle123

Thank you for your reply, do you know of a way where i can see that Excel.Application.Selection is returning a range object?

 

[RoryA]

You can only test that at runtime, since different things could be selected.