Yes. I always use option explicit. Therefore, the object would be declared (as workbook, as worksheet, etc.

Joh

----- Tom Ogilvy wrote: ----

Are your variables declared with a specific type

Dim rng as Rang

for example. If not, then Excel would not know what to show

--
Regards
Tom Ogilv

"John" wrote in messag
..
The VBA IDE does not always pop-up the list of available properties an
methods when the period (.) is added. This behaviour is mostly exhibite
following a collection (e.g., worksheets())
Any ideas how to correct this annoying behaviour
Windows XP, Office X
Thanks
Joh