Problem with auto list members in VBA

[Blegos]

Ok i have a problem with auto list members in Visual
Basic Editor, when i record macro in excel it write me in
module1 a line

VB CODE:
Sheets("Sheet2").Select

ok when i try to write

VB CODE:
Sheets("Sheet2").

and then press "CTRL+SPACE"
wont't show list members. I need this.
I choose the excel 10 reference,......

 

[Dave Ramage]

Auto list members does not work with the Sheets method
(for some reason?) or Worksheets(..) or several other
methods.

An alternative is to use the sheet's object name as seen
in the object tree view. Note that this may be different
to the tab name for the sheet.

E.g.
Sheet1.Activate

Cheers,
Dave.

 

[Dave Peterson]

I sometimes declare a variable just so I can get that help.

Dim wks as worksheet
set wks = worksheets("sheet2")
wks.
that dot will cause good things to happen.