Autocomplete in VBA turned off

[Guest]

How come I don't have autolist in my Excel XP VBA window.
For example, if I hit CTL-G and type Selection. nothing pops up. The same goes
for procedures.
[email protected]

 

[Bernie Deitrick]

Selection doesn't have an autocomplete list, since the selection can be a
range object, a chart object, a commandbutton, a drawing object, etc.

Procedures are part of some other object, like Application, so you type
Application. to get an autolisting of procedures and properties for
Application.

HTH,
Bernie
MS Excel MVP

 

[Guest]

You're right. But how about

sheets(1).range("L18").

I could swear that used to bring up a list.
[email protected]

 

[Bernie Deitrick]

Using the codename for the sheet will:

Sheet1.Range("L18").

or just using the range will:

Range("L18").

Any time there is any ambiguity or doubt on Excel's part, it clams up and is
unhelpful....

HTH,
Bernie
MS Excel MVP

 

[Guest]

Okay. I've been using cells a lot more than range recently. I thought Range
listed properies and methods. I don;t see why it doesn't when youre even more
specific, like listing a sheet first.
[email protected]