Hi Habib

It is generally a good idea to use Option Explicit at the top of every
module (if you set ToolsOptionsEditorRequire Variable Declaration
this will be done automatically for you). You will then be forced to
declare all variables and you should declare them explicitly wherever
possible.

This may also explain your intellisense issues. If you don't declare the
range or declare it as a variant then you will not have access to
intellisense for that variable/object. As soon as you declare it as a
range you should have intellisense.

Hope this helps
Rowan

HSalim[MVP] wrote:
Hello Dave and Rowan,
Thanks for the quick response.
I did see the set syntax in the help files but I was not getting anywhere
with that either till i explicitly declared a range.

I've been experiencing intermittent difficulty with intellisense not
working - any idea why that might be happening. I am able to compile the
priject so i do not have any missing references.

Thanks again for the assistance.
Regards
Habib