Excel's IntelliSense

[Andrzejek]

The IntelliSense is Excel works sometimes, and doesn't other times.

This works every time:

But when I type this, I get some help from Excel:

I keep typing, but then [tt]cells(1, 1).[/tt] dosn't give me any hints after the period
when I want to have: [tt]Cells(1, 1).[blue]Value[/blue][/tt] for example

The same when I want to use [tt]UsedRange[/tt] of the [tt]ActiveSheet[/tt]
So I type:
[tt]activesheet.[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.rows[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.rows.count[/tt]

but then, at the end , I do get:
[tt]ActiveSheet.UsedRange.Rows.Count[/tt]
with all capitalized letters and it works OK

What am I missing...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[combo]

It seems that after Cells(...) intellisense stops at hidden _Default property of Range:

ActiveSheet can be other than Worksheet type, even after UsedRange VBE does not recognize context.

combo