No autolist members for Worksheet object

[antaeusguy]

When I type Range("A1") followed by a dot (.), it autolist it's members (Activate, AddComment etc...)

However, when I type Worksheets("Sheet1"). followed by a dot (.), no autolist members appeared...

Does anyone knows why it didn't propose it's members?

 

[VoG]

If you use

Sheet1.

then you will get the Intellisense.

 

[RoryA]

Because Worksheets(index) returns a generic Object type rather than a Worksheet object. You can either use the code name as Peter suggested, or use a variable:

Dim wks as Worksheet
Set wks = Worksheets("Sheet1")
wks. <-- you will get Intellisense here