Are your variables declared with a specific type.

Dim rng as Range

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

--
Regards,
Tom Ogilvy

"John" wrote in message
...
The VBA IDE does not always pop-up the list of available properties and
methods when the period (.) is added. This behaviour is mostly exhibited
following a collection (e.g., worksheets()).

Any ideas how to correct this annoying behaviour.

Windows XP, Office XP

Thanks,
John