Application.ActiveSheet."WhatNext"

[AthmanArumugam]

HI,

I am currently learning VBA from excel school.I have a quick question.
I can understand that ActiveSheet is one of the property for Application Object.
However we can find the Name, usedRange as well using the statement
Application.ActiveSheet.Name / Application.ActiveSheet.UsedRange.

I would like to know what all properties that ActiveSheet supports.
Although Name and UsedRange can be used along with ActiveSheet, how do I find out what all properties are supported by ActiveSheet from the help document.

Can anyone guide me here.

▬▬▬▬▬▬▬▬▬ Mod edit : not here but in appropriate forum !

(so thread was moved)
​

 

[PCosta87]

Hi,

Please take a look at the following:
https://msdn.microsoft.com/en-us/library/office/ff194464.aspx

You find it by looking for worksheet. Since Activeworksheet is ultimately just a worksheet, it supports the same Events, Methods and Properties

 

[jindon]

While you are in VBE, [View] - [Object browser]
type Worksheet in search box and enter.

It will list all the property/method etc.

 

[AthmanArumugam]

Hi,

Please take a look at the following:
https://msdn.microsoft.com/en-us/library/office/ff194464.aspx

You find it by looking for worksheet. Since Activeworksheet is ultimately just a worksheet, it supports the same Events, Methods and Properties

Thanks . Now I have understood the inner logic in VBA.

 

[Debaser]

ActiveSheet might also be a chart or, less likely, a dialogsheet.

 

[NARAYANK991]

Hi ,

Just to add to what ever has been posted , get into the habit of using the keyword Me instead of ActiveSheet , where ever possible.

http://dailydoseofexcel.com/archives/2004/04/20/the-me-keyword/

https://www.safaribooksonline.com/library/view/programming-excel-with/0596007663/ch04s04.html

Narayan

 

[AthmanArumugam]

Hi ,

Just to add to what ever has been posted , get into the habit of using the keyword Me instead of ActiveSheet , where ever possible.

http://dailydoseofexcel.com/archives/2004/04/20/the-me-keyword/

https://www.safaribooksonline.com/library/view/programming-excel-with/0596007663/ch04s04.html

Narayan

Thanks Narayank991 for the tip on Me command. It is really useful.