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.

Blegos wrote:

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 Peterson